Mr.Combet Webshell 🔥

Edit 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" hidden>
                <label><strong>Grants From RERP</strong></label>
                <div class="inputWithIcon">
                    <input type="text" class="curr form-control  currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="GrantsFromRerp" id="GrantsFromRerp">
                    <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 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>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>Self Investment</strong></label>
                <div class="inputWithIcon">
                    <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="SelfInvestment" id="SelfInvestment">
                    <span><strong>Rs</strong></span>
                </div>
                @* <input type="text" onkeypress="return isNumberKey(this,event)" maxlength="8" class="required form-control" id="SelfInvestment" name="SelfInvestment" />*@
            </div>
            <div class="form-group col-md-2">
                <label><strong>Remittance</strong></label>
                <div class="inputWithIcon">
                    <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="RemittanceInvestmentTab" id="RemittanceInvestmentTab">
                    <span><strong>Rs</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>Rs</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>Rs</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>Loan Source</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</strong></label>
                <div>
                    <select type="text" class="form-control  required" name="SubsidyTypeId" id="SubsidyTypeId" data-api="/subsidy/select"></select>
                </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.MnEExpert || 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 RERP (Rs) </th>*@
                <th style="text-align:center"> Grants From Other Source (Rs) </th>
                <th style="text-align:center"> Self Investment (Rs)</th>
                <th style="text-align:center"> Remittance (Rs)</th>
                <th style="text-align:center"> Other Investment (Rs)</th>
                <th style="text-align:center"> Loan (Rs)</th>
                <th style="text-align:center">Loan Source</th>
                <th style="text-align:center">Subsidy Type</th>
                @if (memberStatus)
                {
                    <th style="text-align:center"> Action</th>
                }

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

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

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 otherInvestmentTotal = 0;
        var loanTotal = 0;
            response.forEach(function (x) {

row += "<td><center>" +Number(parseFloat(x.self_investment).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.other_investment).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>" + x.subsidy_name + "</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);
                     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);
        table.append(row);
            })

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

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

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

<td style="white-space:nowrap;"><strong><center> Rs. ${Number(parseFloat(selfInvestmentTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                    <td style="white-space:nowrap;"><strong><center> Rs. ${Number(parseFloat(remittanceTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                    <td style="white-space:nowrap;"><strong><center> Rs. ${Number(parseFloat(otherInvestmentTotal).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                    <td style="white-space:nowrap;"><strong><center> Rs. ${Number(parseFloat(loanTotal).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 () {

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() {

var farmerDiaryInvestmentPlan = {};
                 farmerDiaryInvestmentPlan.Id = allFormData.Id;
                 farmerDiaryInvestmentPlan.GrantsFromProvincePalika = removeCommaFromString(allFormData.GrantsFromProvincePalika);
                 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() {

//var salesQuantity = removeCommaFromString($("#SalesQuantity").val());

//$('#TotalSalesAmount').val(getNumberWithComma(sum));
             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 ) {

const ajax = request(investmentPlanId);

function request(investmentPlanId) {

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

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

}
           ajax.done(function (response) {

console.log(response);
               $('#InvestmentPlanId').val(response.Id);
               $('#GrantsFromProvincePalika').val(getNumberWithComma(response.GrantsFromProvincePalika));
               $('#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 (getNumberWithComma(response.Loan) > 0) {
                      $('.loan-source-div').show();
                   $('#LoanSourceId').val(getNumberWithComma(response.LoanSourceId));
                   $('#SubsidyTypeId').val(getNumberWithComma(response.SubsidyTypeId));
               }

window.scrollTo(200, 0);

});

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

function clearAlltableInvestmentPlan() {
          $("#InvestmentPlanId").val('');
        //$("#FiscalYear").val('');
        //$("#Quadtrimester").val('');
        $('#GrantsFromProvincePalika').val('');
        $('#GrantsFromRerp').val('');
        $('#GrantsFromOtherSource').val('');
        $('#SelfInvestment').val('');
        $('#RemittanceInvestmentTab').val('');
        $('#OtherInvestment').val('');
        $('#LoanInvestmentTab').val('');
        $('#LoanSourceId').val('');
        $('#SubsidyTypeId').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>