Mr.Combet Webshell 🔥

View File Name : _FarmerDiaryInvestmentPlanTab.cshtml



@model RER_Project.DataAccess.ViewModels.Baseline.BaselineViewModel
@using RER_Project.Core.Helpers;
@using RER_Project.BusinessLayer.BusinessService

@{
    var meta = AppUserService.GetCurrent();
}
@{
    var memberStatus = Model.MemberDetailView.IsActive;
}
@if (memberStatus)
{
<form id="CreateInvestmentPlan">
    <div id="eror_msg"></div>
    <div class="row">
        <input type="hidden" name="Id" id="InvestmentPlanId" />
        <!--<div class="form-group col-md-2">-->
        @*  <label><strong>GrantsFromProvincePalika</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="GrantsFromProvincePalika" id="GrantsFromProvincePalika">
                <span><strong>Rs</strong></span>
            </div>*@
        @*   <input type="text" onkeypress="return isNumberKey(this,event)" maxlength="8" class="required form-control" id="Grants" name="Grants" />*@
        <!--</div>-->
        <div class="form-group col-md-2">
            <label><strong>Grants From Map</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="GrantsFromRerp" id="GrantsFromRerp">
                <span><strong>MVR</strong></span>
            </div>
            @*   <input type="text" onkeypress="return isNumberKey(this,event)" maxlength="8" class="required form-control" id="Grants" name="Grants" />*@
        </div>
        <div class="form-group col-md-2">
            <label><strong>Grants From Other Source</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="GrantsFromOtherSource" id="GrantsFromOtherSource">
                <span><strong>MVR</strong></span>
            </div>
            @*   <input type="text" onkeypress="return isNumberKey(this,event)" maxlength="8" class="required form-control" id="Grants" name="Grants" />*@
        </div>



        <div class="form-group col-md-2">
            <label><strong>Self Investment Remittance</strong> </label>
            <div class="inputWithIcon">


                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="SelfInvestmentremittance" id="SelfInvestmentremittance">
                <span><strong>MVR</strong></span>
            </div>
        </div>
        <div class=" form-group col-md-2">
            <label><strong>Self Investment Other Farming</strong> </label>
            <div class="inputWithIcon">

                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="SelfInvestmentfarming" id="SelfInvestmentfarming">
                <span><strong>MVR</strong></span>
            </div>
        </div>


        @* <input type="text" onkeypress="return isNumberKey(this,event)" maxlength="8" class="required form-control" id="SelfInvestment" name="SelfInvestment" />*@

        <div class="form-group col-md-2">
            <label><strong>Other Investment (If Any)</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="RemittanceInvestmentTab" id="RemittanceInvestmentTab">
                <span><strong>MVR</strong></span>
            </div>
            @*<input type="text" onkeypress="return isNumberKey(this,event)" maxlength="8" class="required form-control" id="RemittanceInvestmentTab" name="Remittance" />*@
        </div>
        <!--<div class="form-group col-md-2">
            <label><strong>Other Investment</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="OtherInvestment" id="OtherInvestment">
                <span><strong>MVR</strong></span>
            </div>-->
        @*   <input type="text" onkeypress="return isNumberKey(this,event)" maxlength="8" class="required form-control" id="OtherInvestment" name="OtherInvestment" />*@
        <!--</div>-->
        <!--<div class="form-group col-md-2">
            <label><strong>Loan</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control currencyFormatter " onkeypress="return isNumberKey(this,event)" maxlength="12" name="LoanInvestmentTab" id="LoanInvestmentTab">
                <span><strong>MVR</strong></span>
            </div>-->
        @*  <input type="text" onkeypress="return isNumberKey(this,event)" maxlength="8" class="required form-control" id="LoanInvestmentTab" name="Loan" />*@
        <!--</div>

        <div class="form-group col-md-2 loan-source-div">
            <label><strong> Bank Name</strong></label>
            <div>
                <select type="text" class="form-control  required" name="LoanSourceId" id="LoanSourceId" data-api="/banks/select/all"></select>
            </div>
        </div>

        <div class="form-group col-md-2 loan-source-div">
            <label><strong>Subsidy Amount</strong></label>
            <div class="inputWithIcon">
                <input type="text" class="curr form-control currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="Subsidyid" id="Subsidyid">
                <span><strong>MVR</strong></span>
            </div>
        </div>-->

        <div class="form-group col-md-2">
            <label>&nbsp;</label><br />
            @if (meta.RoleId == (int)EnumRoleHelper.Roles.Admin || meta.RoleId == (int)EnumRoleHelper.Roles.ProjectDirector || meta.RoleId == (int)EnumRoleHelper.Roles.BDS || meta.RoleId == (int)EnumRoleHelper.Roles.MnE || meta.RoleId == (int)EnumRoleHelper.Roles.MnEOfficer)
            {
                <input type="button" value="Save" class="btn btn-primary" id="SubmitInvestmentPlan" />
            }
            <a href="/farmer_diary/time_frame/member/@Model.MemberDetailView.Id" class="btn btn-default"><i class="fa fa-arrow-circle-o-left" aria-hidden="true"></i> Back</a>
        </div>
    </div>


</form>
}

<div class="row">
    <div class="col-lg-12">
        <a class="btn btn-primary btnPrevious"><i class="fa fa-arrow-circle-o-left" aria-hidden="true"></i> &nbsp;Previous</a>
        <a class="btn btn-primary btnNext">Next <i class="fa fa-arrow-circle-o-right" aria-hidden="true"></i></a>
    </div>
</div>
<div class="table-responsive" style="margin-top: 16px;">
    <table class="table table-bordered table-hover" name="tblInvestmentPlan" id="tblInvestmentPlan">
        <thead>
            <tr>
                @*<th>Fiscal Year </th>
                    <th>Quadrimester</th>*@
                @*  <th style="text-align:center"> Grants From Province / Palika (Rs) </th>*@
                <th style="text-align:center"> Grants From Map (MVR) </th>
                <th style="text-align:center"> Grants From Other Source (MVR) </th>
                <th style="text-align:center"> Self Investment Remitance (MVR)</th>
                <th style="text-align:center"> Self Investment Farming(MVR)</th>
                <th style="text-align:center"> Other Investment (MVR)</th>
                <th style="text-align:center"> Loan (MVR)</th>
                <th style="text-align:center">Bank Name</th>
                <th style="text-align:center">Subsidy Amount (MVR)</th>
                @if (memberStatus)
                {
    <th style="text-align:center"> Action</th>
}

            </tr>
        </thead>
        <tbody>
        </tbody>

        <tfoot style="line-height:30px;background-color:#edf0ee;color:black" id="tblInvestmentFooter">

        </tfoot>
    </table>
</div>

<script type="text/javascript">

    function loadInvestment() {
        $('.loan-source-div').hide();

             const ajax = request();

         function request() {

            const url = '/farmer_diary/investment_plan/member/' + @Model.MemberDetailView.Id + '/fiscal/' + @ViewBag.FiscalYear;

             return window.getAjaxRequest(url, "Get", @Model.MemberDetailView.Id);
            }


        ajax.done(function (response) {

              addInvestmentPlanListToTable(response);
        });

        ajax.fail(function (xhr) {
            ShowMessage("error", xhr.responseText);
        });
    }

    function addInvestmentPlanListToTable(response)
    {

        var status = '@memberStatus';

        if (response.length == 0) {
            $('#tblInvestmentFooter').hide();
        }
        else {
               $('#tblInvestmentFooter').show();
        }
        $('#tblInvestmentPlan tbody > tr').remove();
        $('#tblInvestmentPlan tfoot > tr').remove();
        var table = $("#tblInvestmentPlan tbody");
        var grantFromProvincePalikaTotal = 0;
        var grantFromRerpTotal = 0;
        var grantFromOtherSourceTotal = 0;
        var selfInvestmentTotal = 0;
        var remittanceTotal = 0;
        var subsidyAmount = 0;
        var grandfromothersource = 0;
        var selfremitance = 0;
        var selfremitancefarming = 0;
        var otherInvestmentTotal = 0;
        var loanTotal = 0;
            response.forEach(function (x) {

                var row = "<tr>";
                //row += "<td>" +x.fiscal_year+ "</td>";
                //row += "<td>" + x.quadrimester + "</td>";
              @*  row += "<td><center>" + Number(parseFloat(x.grants_from_province_palika).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 }) + "</center></td>";*@
                row += "<td><center>" + Number(parseFloat(x.grants_from_rerp).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 }) + "</center></td>";
                row += "<td><center>" + Number(parseFloat(x.grants_from_other_source).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 }) + "</center></td>";

                row += "<td><center>" + Number(parseFloat(x.self_remittance).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })  + "</center></td>";
                row += "<td><center>" + Number(parseFloat(x.self_remittance_other_farming).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 }) + "</center></td>";
                row += "<td><center>" + Number(parseFloat(x.remittance).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })  + "</center></td>";
                row += "<td><center>" + Number(parseFloat(x.loan).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })  + "</center></td>";
                row += "<td><center>" + x.loan_source + "</center></td>";
                row += "<td><center>" + Number(parseFloat(x.subsidy_amount).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 }) + "</center></td>";

                row += "<td class='hideshow'>" + "<a class='btn btn-default btn-xs' style='color:dodgerblue' onclick=editInvestmentPlanForm(" + x.id + ") ><i  class='fa fa-edit'></i >"
                    + "</a >&nbsp;&nbsp;<a class='btn btn-default btn-xs' style='color:dodgerblue' onclick=deleteInvestmentPlanByInvestmentPlanId(" + x.id + ") ><i class='fa fa-trash'></i ></a>" +
                     "&nbsp;&nbsp;<span" +" style='cursor:pointer'  onclick=showFarmerDiaryInvestmentPlanRecommendPopUp(" + x.id + ")  class='badge'>Recommend</span> </center></td >"


                grantFromProvincePalikaTotal += parseFloat(x.grants_from_province_palika);
                grantFromRerpTotal += parseFloat(x.grants_from_rerp);
                selfremitance += parseFloat(x.self_remittance);
                selfremitancefarming += parseFloat(x.self_remittance_other_farming);

                grandfromothersource += parseFloat(x.grants_from_other_source);
                     grantFromOtherSourceTotal += parseFloat(x.grants_from_other_source);
                 selfInvestmentTotal += parseFloat(x.self_investment);
                remittanceTotal += parseFloat(x.remittance);
                otherInvestmentTotal += parseFloat(x.other_investment);
                loanTotal += parseFloat(x.loan);
                subsidyAmount += parseFloat(x.subsidy_amount);
        table.append(row);
            })

           var tblFooter = $("#tblInvestmentPlan tfoot");
         var footerRow = `<tr>
                    <td style="white-space:nowrap;"><strong>Total : MVR.  ${Number(parseFloat(grantFromRerpTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</strong></td>

                  <td style="white-space:nowrap;"><strong>  MVR.  ${Number(parseFloat(grandfromothersource).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</strong></td>

                  <td style="white-space:nowrap;"><strong>  MVR.  ${Number(parseFloat(selfremitance).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</strong></td>


                    <td style="white-space:nowrap;"><strong><center> MVR. ${Number(parseFloat(selfremitancefarming).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                    <td style="white-space:nowrap;"><strong><center> MVR. ${Number(parseFloat(remittanceTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                    <td style="white-space:nowrap;"><strong><center> MVR. ${Number(parseFloat(loanTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
<td></td>
                    <td style="white-space:nowrap;"><strong><center> MVR. ${Number(parseFloat(subsidyAmount).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td><td></td><td></td>
                    <td class='hideshow'></td>
                    </tr>`
        tblFooter.append(footerRow);


        if (status === 'False') {
            $('.hideshow').hide();
        }
    }



    $("#SubmitInvestmentPlan").off("click").on("click", function () {
        debugger;
            function request(model) {
                const url = "/farmer_diary/investment_plan/create";
                const data = JSON.stringify(model);
                return window.getAjaxRequest(url, "POST", data);
            }
            const form = $("#CreateInvestmentPlan");

            $.validator.unobtrusive.parse(form);

           var allFormData = window.serializeForm(form);

           if (allFormData.LoanInvestmentTab == "") {
               $("#LoanSourceId").removeClass("required");
           }
           if (allFormData.LoanInvestmentTab == "") {
               $("#SubsidyTypeId").removeClass("required");
           }

            if (!form.valid()) {
                return false;
            };

            if (!window.confirmAction()) {
                return;
            };

            WorkForce.loader.show();
            function getModel() {
             return (getFarmerDiaryInvestmentPlan());
            }
             function getFarmerDiaryInvestmentPlan() {
                 debugger;
                 var farmerDiaryInvestmentPlan = {};

                 farmerDiaryInvestmentPlan.Id = allFormData.Id;
                 farmerDiaryInvestmentPlan.SelfRemittance = removeCommaFromString(allFormData.SelfInvestmentremittance);
                 farmerDiaryInvestmentPlan.SelfRemittanceOtherFarming = removeCommaFromString(allFormData.SelfInvestmentfarming);
                 @*farmerDiaryInvestmentPlan.SubsidyAmount = removeCommaFromString(allFormData.Subsidyid);*@


                 farmerDiaryInvestmentPlan.GrantsFromRerp = removeCommaFromString(allFormData.GrantsFromRerp);
                    farmerDiaryInvestmentPlan.GrantsFromOtherSource = removeCommaFromString(allFormData.GrantsFromOtherSource);
      @*          farmerDiaryInvestmentPlan.SelfInvestment = removeCommaFromString(allFormData.SelfInvestment);*@
                farmerDiaryInvestmentPlan.Remittance =removeCommaFromString(allFormData.RemittanceInvestmentTab);
              @*  farmerDiaryInvestmentPlan.OtherInvestment = removeCommaFromString(allFormData.OtherInvestment);*@
                @* farmerDiaryInvestmentPlan.Loan =removeCommaFromString(allFormData.LoanInvestmentTab);*@
                 farmerDiaryInvestmentPlan.FiscalYear = @ViewBag.FiscalYear
                 farmerDiaryInvestmentPlan.Quadrimester = '@ViewBag.Quadrimester'
                 farmerDiaryInvestmentPlan.MemberId = @Model.MemberDetailView.Id;
                 farmerDiaryInvestmentPlan.BaselineId = @Model.Baseline.Id;
                 farmerDiaryInvestmentPlan.GroupId = @Model.MemberDetailView.GroupId;
                 farmerDiaryInvestmentPlan.DistrictId = '@Model.MemberDetailView.DistrictId';
                 farmerDiaryInvestmentPlan.LoanSourceId = allFormData.LoanSourceId;
@*                 farmerDiaryInvestmentPlan.SubsidyTypeId = allFormData.SubsidyTypeId;*@
                return farmerDiaryInvestmentPlan;
            }


             const model = getModel();

            const ajax = request(model);

            ajax.done(function (response) {

                WorkForce.loader.hide();
                showNotification("success");
                loadInvestment();
                //addCurrentlyInsertedInvestmentPlanToTable(aInvestmentData);
                clearAlltableInvestmentPlan();
              //  showAllTabs(response);
                //window.location = "/groups";
            });



            ajax.fail(function (xhr) {
                WorkForce.loader.hide();
                ShowMessage("error", xhr.responseText);
            });

       })


    @*$("#LoanInvestmentTab").bind("change paste keyup", function () {
        debugger
             var loanRs = removeCommaFromString($('#LoanInvestmentTab').val());

             if (loanRs > 0) {
                 $("#LoanSourceId").addClass("required");
                 $("#SubsidyTypeId").addClass("required");
                 $('.loan-source-div').show();
             }
             else {
                 $("#LoanSourceId").removeClass("required");
                 $("#SubsidyTypeId").removeClass("required");
                 $('#LoanSourceId').val('');
                 $('#SubsidyTypeId').val('');
                   $('.loan-source-div').hide();
             }

         });*@



    function editInvestmentPlanForm(investmentPlanId) {
        debugger;
        const ajax = request(investmentPlanId);

        function request(investmentPlanId) {

            const url = '/farmer_diary/investment_plan/' + investmentPlanId;

            return window.getAjaxRequest(url, "Get", investmentPlanId);


        }
        debugger;
        ajax.done(function (response) {
              console.log(response);
               $('#InvestmentPlanId').val(response.Id);
               $('#SelfInvestmentremittance').val(getNumberWithComma(response.SelfRemittance));
               $('#SelfInvestmentfarming').val(getNumberWithComma(response.SelfRemittanceOtherFarming));
               $('#Subsidyid').val(getNumberWithComma(response.SubsidyAmount));
               $('#GrantsFromRerp').val(getNumberWithComma(response.GrantsFromRerp));
               $('#GrantsFromOtherSource').val(getNumberWithComma(response.GrantsFromOtherSource));
               $('#SelfInvestment').val(getNumberWithComma(response.SelfInvestment));
               $('#RemittanceInvestmentTab').val(getNumberWithComma(response.Remittance));
               $('#OtherInvestment').val(getNumberWithComma(response.OtherInvestment));
               @*$('#LoanInvestmentTab').val(getNumberWithComma(response.Loan));
               if (response.Loan > 0) {
                   $('.loan-source-div').show();
                   $('#LoanSourceId').val(response.LoanSourceId);
                   $('#SubsidyTypeId').val(getNumberWithComma(response.SubsidyTypeId));
               }*@

               window.scrollTo(200, 0);

        });

        ajax.fail(function (xhr) {
            ShowMessage("error", xhr.responseText);
        });
    }


    function clearAlltableInvestmentPlan() {
          $("#InvestmentPlanId").val('');
        $('#GrantsFromProvincePalika').val('');
        $('#GrantsFromRerp').val('');
        $('#GrantsFromOtherSource').val('');
        $('#SelfInvestment').val('');
        $('#RemittanceInvestmentTab').val('');
        $('#OtherInvestment').val('');
        $('#LoanInvestmentTab').val('');
        $('#LoanSourceId').val('');
        $('#Subsidyid').val('');
    }

    function deleteInvestmentPlanByInvestmentPlanId(investmentPlanId) {
           let conf = confirm(`Are you sure you want to delete this Investment Plan ?`);
        if (!conf) {

            return;
        } else {

            const ajaxResponse = requestInvestmentPlanToDelete(investmentPlanId);

            ajaxResponse.done(function (response) {
                WorkForce.loader.hide();
                if (response) {
                    loadInvestment();
                    clearAlltableInvestmentPlan();
                    ShowMessage("success", "Successfully Deleted this Investment Plan");
                }

                WorkForce.loader.hide();
            });

            ajaxResponse.fail(function (xhr) {
                WorkForce.loader.hide();
                ShowMessage("Error", xhr.responseText);
            });

            WorkForce.loader.hide();


        }
    }

    function requestInvestmentPlanToDelete(investmentPlanId) {
            const url = "/farmer_diary/investment_plan/delete/";
            const data = JSON.stringify({ "Id": investmentPlanId});
            return window.getAjaxRequest(url, "POST", data);
    }


   function showFarmerDiaryInvestmentPlanRecommendPopUp(id) {

        $('#recommendFarmerDiaryModel').modal('show');
        $('#RowIdInPopUp').val(id);
        $('#TableName').val('FarmerDiaryInvestmentPlan');
    }

</script>