Odex-Upwork Portfolio

 

PROFILE::: UPWORK

Ajax form submit MVC

@using (Ajax.BeginForm("ApproveBatchCollectSheet", "CollectionSheet", new AjaxOptions { HttpMethod = "POST", UpdateTargetId = "result", OnComplete = "OnComplete" }))

 

@using (Ajax.BeginForm("Action", "ControllerName", new AjaxOptions { HttpMethod = "POST", UpdateTargetId = "result", OnComplete = "OnComplete" }))

{

  <div class="modal-footer">

        <button type="submit" tabindex="@maxTabIndex" class="btn btn-primary btn-approve-batch-cs"><i class="fa fa-check"></i> Collect</button>

        <button type="button" tabindex="@maxTabIndex" id="btnCloseModal" class="btn btn-danger" data-dismiss="modal"><i class="fa fa-times"></i> Close</button>

    </div>

}

<script>

    function OnComplete(xhr, status, error) {

        //alert(xhr.responseText);

        $.alert.open(xhr.responseText);

         

        $('#GlobalPopupModal').modal('toggle');

        //reload grid data

        CollectionSheetManager.GetCollectionSheetList();

    }

</script>

Portfolio-KHALID

 

Flora Systems Ltd:

Vault management:

Vault Management is a built-in module of Flora Bank. At the beginning of the day, the vault officer pays cash to the teller for daily operation and receives the balance of the cash from the teller, and deposits to the vault at end of the day. The following are covered.  Daily Cash Position in Vault  Teller wise Cash Position  Teller Wise Cash Received Register  Auto Generate Cash Memo  Cash Safe Register

SET 0 in left of string digits

 SELECT  RIGHT('000'+ISNULL(ID_String,''),4), * FROM ExcelData_K

ORDER BY ID

Excel Float Short Form value fixed

 =TEXT(C2,"00%") 

Now upload excel file to sql server. then remove last 3 characters. Use: =TEXT(C2,"00%")

Delete last 3 Characters in SQL

  DECLARE @String NVARCHAR(100)

    SET @String = '12354851'
    SELECT LEFT(@String, NULLIF(LEN(@String)-1,-1))