Mr.Combet Webshell 🔥

Edit File Name : CooperativeDetailsCreate.cshtml

@model RER_Project.DataAccess.ViewModels.Cooperative.CooperativeDetailsVM
@{
    var coopId = @ViewContext.RouteData.Values["coopId"];
}
@using RER_Project.Core.Helpers
@using RER_Project.BusinessLayer.BusinessService
@{

var meta = AppUserService.GetCurrent();
}
<div class="row wrapper border-bottom white-bg page-heading">

<div class="col-md-12">
        <strong><span style="font-size:medium">Cooperative Details (Add / Edit)</span></strong><br />
        <br />
        <span style="font-size: 100%;">
            &nbsp;&nbsp;&nbsp;&nbsp;Cooperative Name: <strong>@Model.CooperativeShortInfo.CooperativeName</strong>
        </span>
        <span style="font-size: 100%;">
            &nbsp;&nbsp;&nbsp; Coopertive Type: <strong>@Model.CooperativeShortInfo.CooperativeType</strong>
        </span>
        <span style="font-size: 100%;">
            &nbsp;&nbsp;&nbsp; Cooperative No: <strong> @Model.CooperativeShortInfo.CooperativeType</strong>
        </span>
    </div>

<div class="col-md-12">
        <br />
        <span style="font-size: 100%;">
            &nbsp;&nbsp;&nbsp;&nbsp;Province: <strong>@Model.CooperativeShortInfo.Province</strong>
        </span>
        <span style="font-size: 100%;">
            &nbsp;&nbsp;&nbsp; District: <strong>@Model.CooperativeShortInfo.District</strong>
        </span>
        <span style="font-size: 100%;">
            &nbsp;&nbsp;&nbsp; Municipality: <strong> @Model.CooperativeShortInfo.Municipality</strong>
        </span>
        <span style="font-size: 100%;">
            &nbsp;&nbsp;&nbsp; Ward: <strong> @Model.CooperativeShortInfo.Ward</strong>
        </span>
    </div>
</div>

<div class="row">
                        <div class="form-group col-md-3">
                            <label><strong>Fiscal Year</strong></label>
                            <input type="hidden" name="Id" id="Id" />
                            <input type="hidden" name="CooperativeId" id="CooperativeId" value="@coopId" />
                            <input type="hidden" name="OldFiscalYearId" id="OldFiscalYearId" />
                            <select type="text" class="form-control required" name="FiscalYearId" id="FiscalYearId" data-api="/fiscal_year_unlocked/select"></select>
                        </div>
                        <div class="form-group col-md-3">
                            <label><strong>No. of Male Member</strong></label>
                            <input type="text" pattern="\d*" maxlength="4" min="0" oninput="validity.valid||(value='');" class="required form-control" id="MaleMemberCount" name="MaleMemberCount" />
                        </div>

<div class="form-group col-md-3">
                            <label><strong>No. of Female Member</strong></label>
                            <input type="text" pattern="\d*" maxlength="4" min="0" oninput="validity.valid||(value='');" class="required form-control" id="FemaleMemberCount" name="FemaleMemberCount" />
                        </div>

<div class="form-group col-md-3">
                            <label><strong>No. of Branch</strong></label>
                            <input type="text" pattern="\d*" maxlength="3" min="0" oninput="validity.valid||(value='');" class="required form-control" id="BranchCount" name="BranchCount" />
                        </div>
                    </div>

<div class="form-group col-md-3">
                            <label><strong>No. of Employee</strong></label>
                            <input type="text" pattern="\d*" maxlength="5" class="required form-control" min="0" oninput="validity.valid||(value='');" name="EmployeeCount" id="EmployeeCount">

@*  <input type="text" step="0.000000000000001" maxlength="15" min="0" oninput="validity.valid||(value='');" class="required form-control" id="EmployeeCount" name="EmployeeCount" />*@
                        </div>

<div class="form-group col-md-3">
                            <label><strong>Share Capital</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="ShareCapitalAmount" id="ShareCapitalAmount">
                                <span><strong>Rs</strong></span>
                            </div>
                            @* <input type="text" step="0.00000000001" maxlength="15" min="0" oninput="validity.valid||(value='');" class="required form-control" id="ShareCapitalAmount" name="ShareCapitalAmount" />*@
                        </div>

<div class="form-group col-md-3">
                            <label><strong>General Reserve</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="GeneralReserve" id="GeneralReserve">
                                <span><strong>Rs</strong></span>
                            </div>
                            @* <input type="number" class="required form-control" id="GeneralReserve" name="GeneralReserve" />*@
                        </div>
                        <div class="form-group col-md-3">
                            <label><strong>Other Reserve</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="OtherReserve" id="OtherReserve">
                                <span><strong>Rs</strong></span>
                            </div>
                            @*<input type="number" class="required form-control" id="OtherReserve" name="OtherReserve" />*@
                        </div>
                    </div>

<div class="form-group col-md-3">
                            <label><strong>Saving Amount</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="SavingAmount" id="SavingAmount">
                                <span><strong>Rs</strong></span>
                            </div>
                            @* <input type="number" class="required form-control" id="SavingAmount" name="SavingAmount" />*@
                        </div>

<div class="form-group col-md-3">
                            <label><strong>External Loan Amount</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="ExternalLoanAmount" id="ExternalLoanAmount">
                                <span><strong>Rs</strong></span>
                            </div>
                            @* <input type="number" class="required form-control" id="ExternalLoanAmount" name="ExternalLoanAmount" />*@
                        </div>

<div class="form-group col-md-3">
                            <label><strong>Loan OutStanding Amount</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="LoanOutstandingAmount" id="LoanOutstandingAmount">
                                <span><strong>Rs</strong></span>
                            </div>
                            @*  <input type="number" class="required form-control" id="LoanOutstandingAmount" name="LoanOutstandingAmount" />*@
                        </div>
                        <div class="form-group col-md-3">
                            <label><strong>Total Assets Amount</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="TotalAssetsAmount" id="TotalAssetsAmount">
                                <span><strong>Rs</strong></span>
                            </div>
                            @*  <input type="number" class="required form-control" id="TotalAssetsAmount" name="TotalAssetsAmount" />*@
                        </div>
                    </div>

<div class="form-group col-md-3">
                            <label><strong>Total Income Amount</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="TotalIncomeAmount" id="TotalIncomeAmount">
                                <span><strong>Rs</strong></span>
                            </div>
                            @*   <input type="number" class="required form-control" id="TotalIncomeAmount" name="TotalIncomeAmount" />*@
                        </div>

<div class="form-group col-md-3">
                            <label><strong>Total Expense Amount</strong></label>
                            <div class="inputWithIcon">
                                <input type="text" class="curr form-control required currencyFormatter" onkeypress="return isNumberKey(this,event)" maxlength="12" name="TotalExpensesAmount" id="TotalExpensesAmount">
                                <span><strong>Rs</strong></span>
                            </div>
                            @* <input type="number" class="required form-control" id="TotalExpensesAmount" name="TotalExpensesAmount" />*@
                        </div>

<div class="form-group col-md-3" style="padding-top:4px">
                            <br />
                            @if (meta.RoleId == (int)EnumRoleHelper.Roles.Admin @*|| meta.RoleId == (int)EnumRoleHelper.Roles.FinancialInclusionoOfficer*@ || meta.RoleId == (int)EnumRoleHelper.Roles.MnEOfficer || meta.RoleId == (int)EnumRoleHelper.Roles.MnEExpert)
                            {
                                <input type="button" value="Save" class="btn btn-primary" style="cursor:pointer" id="SubmitButton" /><span>&nbsp;&nbsp;</span>
                                <button onclick="clearFormField()" class="btn btn-default"> <i class="fa fa-eraser" aria-hidden="true"></i> Clear</button>
                            }

</div>

</form>

</div>

<div class="ibox-content" style="margin-top:-60px">
                <h3>Cooperative Details List</h3>

<div class="table-responsive" style="margin-top: 16px;">
                    <table class="table table-bordered table-hover" name="tblCooperativeDetails" id="tblCooperativeDetails">
                        <thead>
                            <tr>
                                <th>Fiscal Year </th>
                                <th># of Male </th>
                                <th># of Female </th>
                                <th># of Branch</th>
                                <th> # of Employee</th>
                                <th style="white-space:nowrap;">Share Capital ( Rs )</th>
                                <th style="white-space:nowrap;">General Reserve</th>
                                <th style="white-space:nowrap;">Other Reserve</th>
                                <th style="white-space:nowrap;">Saving Amount (Rs)</th>
                                <th style="white-space:nowrap;">External Loan</th>
                                <th style="white-space:nowrap;">Loan Outstanding</th>
                                <th style="white-space:nowrap;">Total Assets</th>
                                <th style="white-space:nowrap;">Total Income</th>
                                <th style="white-space:nowrap;">Total Expense</th>
                                <th style="white-space:nowrap;">Action</th>
                            </tr>
                        </thead>
                        <tbody id="tblAssetsBody">
                            @foreach (var item in Model.CooperativeDetailsVMList)
                                {
                                    <tr>
                                        <td>@item.FiscalYearName</td>
                                        <td>@item.MaleMemberCount</td>
                                        <td>@item.FemaleMemberCount</td>
                                        <td>@item.BranchCount</td>
                                        <td>@item.EmployeeCount</td>
                                        <td>@item.ShareCapitalAmount</td>
                                        <td>@item.SavingAmount</td>
                                        <td>
                                            <button onclick="editForm(@item.Id)" id="editButton"><i class="fa fa-edit"></i></button>
                                            <a href="#"><i class='fa fa-remove' style='color: red;'></i></a>
                                        </td>
                                    </tr>
                                }
                        </tbody>

</tfoot>
                    </table>

</div>

</div>
        </div>
    </div>

</div>

function loadCoopDetails() {
        WorkForce.loader.show();
         const ajaxl = request();

function request() {

const url = '/cooperative/details/list?id=' + @coopId;

return window.getAjaxRequest(url, "Get", @coopId);
        }
          ajaxl.done(function (response) {

addCoopDetailsToTable(response);
                scrollToTop();

});

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

function addCoopDetailsToTable(response) {

if (response.length == 0) {
            $('#tblCooperativeDetailFooter').hide();
        }
        else {
             $('#tblCooperativeDetailFooter').show();
        }

$('#tblCooperativeDetails tbody > tr').remove();
          $('#tblCooperativeDetails tfoot > tr').remove();
        var table = $("#tblCooperativeDetails tbody");

var shareAmount = 0, generalReserve = 0, otherReserve = 0, savingAmount = 0, externalLoan = 0, loanOutStanding = 0, totalAsset = 0, totalIncome = 0, totalExpense = 0;

response.forEach(function (x) {
        var row = "<tr>";
            row += "<td>" + x.FiscalYearName + "</td>";
            row += "<td>" + getNumberWithComma(x.MaleMemberCount) + "</td>";
            row += "<td>" + getNumberWithComma(x.FemaleMemberCount) + "</td>";

row += "<td>" + getNumberWithComma(x.BranchCount) + "</td>";
            row += "<td>" + getNumberWithComma(x.EmployeeCount) + "</td>";

row += "<td>" + getNumberWithComma(x.ShareCapitalAmount) + "</td>";

row += "<td>" + getNumberWithComma(x.GeneralReserve) + "</td>";
               row += "<td>" + getNumberWithComma(x.OtherReserve) + "</td>";

row += "<td>" + getNumberWithComma(x.SavingAmount) + "</td>";
            row += "<td>" + getNumberWithComma(x.ExternalLoanAmount) + "</td>";
            row += "<td>" + getNumberWithComma(x.LoanOutstandingAmount) + "</td>";
            row += "<td>" + getNumberWithComma(x.TotalAssetsAmount) + "</td>";
            row += "<td>" + getNumberWithComma(x.TotalIncomeAmount) + "</td>";
              row += "<td>" + getNumberWithComma(x.TotalExpensesAmount) + "</td>";
            row += "<td class='white-space:nowrap;'>" + "<a class='btn btn-default btn-xs' style='cursor:pointer;color:dodgerblue' onclick=editForm(" + x.Id + ") ><i class='fa fa-edit'></i></a>"
                + "<a class='btn btn-default btn-xs' style = 'cursor:pointer;color:dodgerblue' onclick = deleteCooperativeDetail(" + x.Id + ",\"" + x.FiscalYear + "\") > <i class='fa fa-trash'></i></a ></td > ";

shareAmount += parseFloat(x.ShareCapitalAmount);
            generalReserve += parseFloat(x.GeneralReserve);
            otherReserve += parseFloat(x.OtherReserve);
            savingAmount += parseFloat(x.SavingAmount);
            externalLoan += parseFloat(x.ExternalLoanAmount);
            loanOutStanding += parseFloat(x.LoanOutstandingAmount);
            totalAsset += parseFloat(x.TotalAssetsAmount);
            totalIncome += parseFloat(x.TotalIncomeAmount);
            totalExpense += parseFloat(x.TotalExpensesAmount);

table.append(row);
        })

var tblFooterForCooperativeDetailTable = $("#tblCooperativeDetails tfoot");
         var footerRow = `<tr>
                    <td ><strong>Total:</strong></td>
                    <td colspan="4"></td>

<td><strong><center> Rs. ${Number(parseFloat(shareAmount).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                     <td>   <strong><center> Rs. ${Number(parseFloat(generalReserve).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>

<td>  <strong><center> Rs. ${Number(parseFloat(otherReserve).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
 <td> <strong><center> Rs. ${Number(parseFloat(savingAmount).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                      <td>  <strong><center> Rs. ${Number(parseFloat(externalLoan).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                    <td>    <strong><center> Rs. ${Number(parseFloat(loanOutStanding).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                      <td>  <strong><center> Rs. ${Number(parseFloat(totalAsset).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                        <td><strong><center> Rs. ${Number(parseFloat(totalIncome).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>
                    <td>    <strong><center> Rs. ${Number(parseFloat(totalExpense).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 2 })}</center></strong></td>

<td></td></tr>`
         tblFooterForCooperativeDetailTable.append(footerRow);

WorkForce.loader.hide();
    }

function editForm(id) {
        WorkForce.loader.show();
        const ajax = request(id);

function request(id) {

const url = '/cooperatives/edit/details?id=' + id;

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

}
          ajax.done(function (response) {

getCooperativeById(response);
                scrollToTop();

});

ajax.fail(function (xhr) {

ShowMessage("error", xhr.responseText);
        });
    }

function getCooperativeById(responseData) {

var cooperative = {};
        console.log(responseData)

document.getElementById('FiscalYearId').value = responseData.FiscalYearId;
        document.getElementById('MaleMemberCount').value = responseData.MaleMemberCount;
        document.getElementById('FemaleMemberCount').value =responseData.FemaleMemberCount;
        $('#Id').val(responseData.Id);
        $('#OldFiscalYearId').val(responseData.FiscalYearId);
        $('#BranchCount').val((responseData.BranchCount));
        $('#EmployeeCount').val((responseData.EmployeeCount));
        $('#ShareCapitalAmount').val(getNumberWithComma(responseData.ShareCapitalAmount));
        $('#GeneralReserve').val(getNumberWithComma(responseData.GeneralReserve));
        $('#OtherReserve').val(getNumberWithComma(responseData.OtherReserve));
        $('#SavingAmount').val(getNumberWithComma(responseData.SavingAmount));
        $('#ExternalLoanAmount').val(getNumberWithComma(responseData.ExternalLoanAmount));
        $('#LoanOutstandingAmount').val(getNumberWithComma(responseData.LoanOutstandingAmount));
        $('#TotalAssetsAmount').val(getNumberWithComma(responseData.TotalAssetsAmount));
        $('#TotalIncomeAmount').val(getNumberWithComma(responseData.TotalIncomeAmount));
        $('#TotalExpensesAmount').val(getNumberWithComma(responseData.TotalExpensesAmount));

WorkForce.loader.hide();
    }

$("#SubmitButton").off("click").on("click", function ()
     {
        function request(model) {
            const url = "/cooperatives/add/details";
            const data = JSON.stringify(model);
            return window.getAjaxRequest(url, "POST", data);
        }

const form = $("#CreateForm");

$.validator.unobtrusive.parse(form);

var allFormData = window.serializeForm(form);

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

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

WorkForce.loader.show();

function getModel() {
            return (
                getCooperativeDetailForInsertOrUpdate()
            );
        }

function getCooperativeDetailForInsertOrUpdate() {

var cooperativeDetailsData = {};
                 cooperativeDetailsData.Id = allFormData.Id;
                cooperativeDetailsData.CooperativeId = allFormData.CooperativeId;
             cooperativeDetailsData.FiscalYearId = allFormData.FiscalYearId;
             cooperativeDetailsData.OldFiscalYearId = allFormData.OldFiscalYearId;
                cooperativeDetailsData.MaleMemberCount = removeCommaFromString(allFormData.MaleMemberCount);
                 cooperativeDetailsData.FemaleMemberCount = removeCommaFromString(allFormData.FemaleMemberCount);
                 cooperativeDetailsData.BranchCount = removeCommaFromString(allFormData.BranchCount);
                 cooperativeDetailsData.EmployeeCount = removeCommaFromString(allFormData.EmployeeCount);
                 cooperativeDetailsData.ShareCapitalAmount = removeCommaFromString(allFormData.ShareCapitalAmount);
             cooperativeDetailsData.GeneralReserve = removeCommaFromString(allFormData.GeneralReserve);
             cooperativeDetailsData.OtherReserve = removeCommaFromString(allFormData.OtherReserve);
             cooperativeDetailsData.SavingAmount = removeCommaFromString(allFormData.SavingAmount);
             cooperativeDetailsData.ExternalLoanAmount = removeCommaFromString(allFormData.ExternalLoanAmount);
                 cooperativeDetailsData.LoanOutstandingAmount = removeCommaFromString(allFormData.LoanOutstandingAmount);
                 cooperativeDetailsData.TotalAssetsAmount = removeCommaFromString(allFormData.TotalAssetsAmount);
                 cooperativeDetailsData.TotalIncomeAmount = removeCommaFromString(allFormData.TotalIncomeAmount);
                 cooperativeDetailsData.TotalExpensesAmount = removeCommaFromString(allFormData.TotalExpensesAmount);
                return cooperativeDetailsData;
         }

const model = getModel();

const ajax = request(model);

ajax.done(function (response) {
            WorkForce.loader.hide();

loadCoopDetails();

resetFormField();

showNotification("success");
        });

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

})

function deleteCooperativeDetail(cooperativeDetailId,fiscalYear) {

let conf = confirm(`Are you sure you want to delete this Cooperative Details of Fiscal Year ${fiscalYear} ?`);
        if (!conf) {

return;
        } else {

const ajaxResponse = requestCooperativeDetailToDelete(cooperativeDetailId);

ajaxResponse.done(function (response) {
                WorkForce.loader.show();
                if (response) {
                    loadCoopDetails();
                    ShowMessage("success", `Successfully Deleted Cooperative Details of Fiscal Year  : ${fiscalYear}`);
                       WorkForce.loader.hide();
                }

WorkForce.loader.hide();
            });

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

WorkForce.loader.hide();

}
    }

function requestCooperativeDetailToDelete(cooperativeDetailId) {
         const url = "/cooperative_detail/delete/";
            const data = JSON.stringify({ "Id": cooperativeDetailId});
            return window.getAjaxRequest(url, "POST", data);
    }

function scrollToTop() {
        var container = document.getElementById('CreateForm');
         container.scrollTop = container.scrollHeight;
    }

function resetFormField() {

document.getElementById('FiscalYearId').value = '';
         document.getElementById('OldFiscalYearId').value = '';
        document.getElementById('MaleMemberCount').value ='';
        document.getElementById('FemaleMemberCount').value = '';

$(BranchCount).val('');
        $(EmployeeCount).val('');
        $(ShareCapitalAmount).val('');
        $(GeneralReserve).val('');
        $(OtherReserve).val('');
        $(SavingAmount).val('');
        $(ExternalLoanAmount).val('');
        $(LoanOutstandingAmount).val('');
        $(TotalAssetsAmount).val('');
        $(TotalIncomeAmount).val('');
        $(TotalExpensesAmount).val('');
    }

function clearFormField() {

let conf = confirm(`Are you sure you want to clear this form ?`);
        if (!conf) {

return;
        } else {

document.getElementById('FiscalYearId').value = '';
            document.getElementById('OldFiscalYearId').value = '';
            document.getElementById('MaleMemberCount').value = '';
            document.getElementById('FemaleMemberCount').value = '';

$(BranchCount).val('');
            $(EmployeeCount).val('');
            $(ShareCapitalAmount).val('');
            $(GeneralReserve).val('');
            $(OtherReserve).val('');
            $(SavingAmount).val('');
            $(ExternalLoanAmount).val('');
            $(LoanOutstandingAmount).val('');
            $(TotalAssetsAmount).val('');
            $(TotalIncomeAmount).val('');
            $(TotalExpensesAmount).val('');
        }
    }

}
  return true;
}

function getNumberWithComma(value) {
      return   Number(parseFloat(value).toFixed(2)).toLocaleString("en-IN", { minimumFractionDigits: 0 })
    }