<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/Main.Master" CodeFile="SmsServiceCharge.aspx.cs" Inherits="Settings_SmsServiceCharge" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
<script>
function SelectAllCheckboxes(spanChk) {
var oItem = spanChk.children;
var theBox = (spanChk.type == "checkbox") ?
spanChk : spanChk.children.item[0];
xState = theBox.checked;
elm = theBox.form.elements;
for (i = 0; i < elm.length; i++)
if (elm[i].type == "checkbox" &&
elm[i].id != theBox.id) {
if (elm[i].checked != xState)
elm[i].click();
}
}
</script>
<script>
$(document).ready(function () {
$('.datePicker').nepaliDatePicker({ changeYear: true });
});
function pageLoad() {
$(".js-example-basic-single").select2({
placeholder: "Select"
});
$('.datePicker').nepaliDatePicker({ changeYear: true });
$('.filter').filter_input({ regex: '[0-9]', events: 'keypress paste' });
}
function printDiv() {
document.getElementById('gvDiv').style.display = "block";
var gridInsideDiv = document.getElementById('gvDiv');
var printWindow = window.open('about:blank', 'Statement', 'left=0,top=0,width=1024,height=768,toolbar=1,scrollbars=1,menubar=1,status=1');
printWindow.document.write(gridInsideDiv.innerHTML);
printWindow.document.close();
printWindow.focus();
printWindow.print();
}
function printToExcel() {
document.getElementById('gvDiv').style.display = "block";
window.open('data:application/vnd.ms-excel,' + encodeURIComponent($('div[id$=gvDiv]').html()));
}
</script>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<asp:UpdatePanel ID="updForm" runat="server">
<ContentTemplate>
<asp:UpdateProgress ID="updProgress" runat="server" AssociatedUpdatePanelID="updForm">
<ProgressTemplate>
<div class="outerDiv1">
</div>
<div class="innerDiv1" title="Processing...">
<div style="margin-top: 7%; margin-left: 40%; margin-right: 10%; margin-bottom: 10%; font-family: Verdana; font-size: medium;">
Processing...
</div>
</div>
</ProgressTemplate>
</asp:UpdateProgress>
<asp:Panel ID="pnlMsgBox" runat="server">
</asp:Panel>
<div class="clear">
</div>
<div class="form_inner">
<ul>
<li>
<label>
Branch *
</label>
<asp:DropDownList ID="ddlBranch" runat="server" AutoPostBack="true" CssClass="js-example-basic-single form-control" OnSelectedIndexChanged="ddlBranch_SelectedIndexChanged">
</asp:DropDownList>
</li>
<li>
<label>
Center *
</label>
<asp:DropDownList ID="ddlCenter" runat="server" CssClass="js-example-basic-single form-control">
</asp:DropDownList>
</li>
</ul>
<div class="clear">
</div>
<div class="btn_sec">
<asp:Button ID="btnView" CssClass="button" runat="server" Text="View" ValidationGroup="v"
OnClick="btnView_Click" />
<input type="button" id="btnPrint" value="Print" class="button" onclick="printDiv();"
visible="false" runat="server" />
<input type="button" id="btnExportToExcel" value="Export to Excel" class="button"
onclick="printToExcel();" runat="server" visible="false" />
</div>
<div class="clear">
</div>
<div id="gvDiv">
<asp:GridView ID="gvsmscharge" runat="server" CssClass="table1" AutoGenerateColumns="false"
HeaderStyle-HorizontalAlign="Center" EmptyDataText="No Record Found"
Width="100%" Font-Size="12px" ShowHeader="true">
<Columns>
<asp:TemplateField HeaderText="" ItemStyle-HorizontalAlign="Center">
<HeaderTemplate>
<input id="chk1" onclick="javascript:SelectAllCheckboxes(this);" runat="server" type="checkbox" />
<asp:Label ID="lblAll" runat="server" Text="All"></asp:Label>
</HeaderTemplate>
<ItemTemplate>
<asp:CheckBox ID="chk" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="MemberNo">
<ItemTemplate>
<asp:Label ID="lblSn" runat="server" Text='<%#Bind("MemberNo") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="AccountNo">
<ItemTemplate>
<asp:Label ID="MemberId" runat="server" Text='<%#Bind("AccountNo") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PhoneNo">
<ItemTemplate>
<asp:Label ID="Name" runat="server" Text='<%#Bind("PhoneNo") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="EnrolledDate">
<ItemTemplate>
<asp:Label ID="LoanNo" runat="server" Text='<%#Bind("EnrolledDate") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="ExpiryDate">
<ItemTemplate>
<asp:Label ID="ODPrin" runat="server" Text='<%#Bind("ExpiryDate") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Balance">
<ItemTemplate>
<asp:Label ID="AddPrinciple" runat="server" Text='<%#Bind("Balance") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Charge">
<ItemTemplate>
<asp:Label ID="Principle" runat="server" Text='<%#Bind("Charge") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</div>
<!--ended Div of Wrapping Form Fields Set-->
</ContentTemplate>
<%--<Triggers>
<asp:PostBackTrigger ControlID="btnView" />
</Triggers>--%>
</asp:UpdatePanel>
</asp:Content>
-----------------------------------------------------------------------
------------------------------------------------------------------
CS
using System;
using System.Collections.Generic;
using System.Drawing;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using ProudMonkey.Common.Controls;
public partial class Menu_Roles : System.Web.UI.Page
{
ProudMonkey.Common.Controls.MessageBox msgbox;
protected void Page_Init(object sender, EventArgs e)
{
msgbox = new MessageBox()
{
};
this.pnlMsgBox.Controls.Clear();
this.pnlMsgBox.Controls.Add(msgbox);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FillgvRoles();
filldropdown();
}
}
#region Roles
protected void btnRole_Click(object sender, EventArgs e)
{
if (((Button)sender).CommandName == "Save")
{
InsUpdDelRoles('I', 0);
}
else
{
InsUpdDelRoles('U', Convert.ToInt32(((Button)sender).CommandArgument));
}
}
protected void gvUsersRoles_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Edit1")
{
try
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gvUsersRoles.Rows[index];
Label roleId = (Label)row.FindControl("lblId");
if (roleId != null)
txtUserRoleId.Text = roleId.Text;
Label lblRoleName = (Label)row.FindControl("lblFullName");
if (lblRoleName != null)
if (lblRoleName.Text != "")
txtRoleName.Text = lblRoleName.Text;
Label lblLoanRequestLimitAmt = (Label)row.FindControl("lblLoanRequestLimitAmt");
if (lblLoanRequestLimitAmt != null)
// if (lblLoanLimit.Text != "")
txtloanrequestlimit.Text = lblLoanRequestLimitAmt.Text;
Label lblLoanApprovalLimitAmt = (Label)row.FindControl("lblLoanApprovalLimitAmt");
if (lblLoanApprovalLimitAmt != null)
// if (lblLoanLimit.Text != "")
txtloanapprovallimit.Text = lblLoanApprovalLimitAmt.Text;
Label lblLoanDisbursementLimitAmt = (Label)row.FindControl("lblLoanDisbursementLimitAmt");
if (lblLoanDisbursementLimitAmt != null)
// if (lblLoanLimit.Text != "")
txtLoanDisbursementLimit.Text = lblLoanDisbursementLimitAmt.Text;
Label lblExpenseLimit = (Label)row.FindControl("lblExpenseLimitAmt");
if (lblExpenseLimit != null)
// if (lblExpenseLimit.Text != "")
txtExpenseLimit.Text = lblExpenseLimit.Text;
var lblrolelevel = (Label)row.FindControl("lblrolelevel");
txtrolelevel.Text = lblrolelevel.Text;
TextFormatting.RemoveZerroForText(txtloanrequestlimit);
TextFormatting.RemoveZerroForText(txtloanapprovallimit);
TextFormatting.RemoveZerroForText(txtLoanDisbursementLimit);
TextFormatting.RemoveZerroForText(txtExpenseLimit);
btnRole.Text = "Update";
// btnRole.CommandName = "Update";
}
catch (Exception ex)
{
msgbox.ShowError("Error :" + ex);
}
}
else if (e.CommandName == "Delete1")
{
InsUpdDelRoles('D', Convert.ToInt32(e.CommandArgument));
}
}
private void InsUpdDelRoles(char Event, int Id)
{
if (txtrolelevel.Text == "")
{
msgbox.ShowWarning("Please Enter Role!!");
return;
}
if (txtRoleName.Text != "")
{
var obj = new BL_Roles();
if (txtloanrequestlimit.Text == "")
txtloanrequestlimit.Text = "0";
if (txtloanapprovallimit.Text == "")
txtloanapprovallimit.Text = "0";
if (txtLoanDisbursementLimit.Text == "")
txtLoanDisbursementLimit.Text = "0";
if (txtloanrequestlimit.Text == "")
txtloanrequestlimit.Text = "0";
if (txtExpenseLimit.Text == "")
txtExpenseLimit.Text = "0";
//For Bank Limit edited by :kamal thapa
if (txtBankLimit.Text == "")
{
txtBankLimit.Text = "0";
}
if (btnRole.Text == "Update")
{
Event = 'U';
Id = int.Parse(txtUserRoleId.Text);
}
else if (btnRole.Text == "Save")
{
Event = 'I';
}
obj.EVENT = Event;
obj.RoleID = Id;
obj.RoleName = txtRoleName.Text;
obj.RoleLevel = int.Parse(txtrolelevel.Text);
obj.LoanRequestLimt = Convert.ToDecimal(txtloanrequestlimit.Text);
obj.LoanApprovalLimt = Convert.ToDecimal(txtloanapprovallimit.Text);
obj.LoanDisbursementLimt = Convert.ToDecimal(txtLoanDisbursementLimit.Text);
obj.ExpenseLimit = Convert.ToDecimal(txtExpenseLimit.Text);
obj.withdrawlimit = Convert.ToDecimal(txtwithdrawlimit.Text);
//For Bank Limit edited by :kamal thapa
obj.BankLimit = Convert.ToDecimal(txtBankLimit.Text);
obj.CreatedBy = M_Session.GetSession().UserId;
obj.CreatedDate = M_Session.GetSession().OP_Date;
string msg = "";
msg = obj.InsUpdDelRoles(out Id);
if(msg== "Record Inserted Successfully")
{
BL_UserActivityLog.SaveSettingActivityLog("", "Child Menu Assigned to role "+ ddlRoleName.SelectedItem.Text);
}
if(msg== "Record Updated Successfully")
{
BL_UserActivityLog.SaveSettingActivityLog("", "Child Menu Updated "+ ddlRoleName.SelectedItem.Text);
}
if(msg== "Record Deleted Successfully")
{
BL_UserActivityLog.SaveSettingActivityLog("", "Child Menu Deleted "+ddlRoleName.SelectedItem.Text);
}
if (msg != "Record Inserted Successfully" || msg != "Record Updated Successfully" || msg != "Record Deleted Successfully")
{
msgbox.ShowSuccess(msg);
FillgvRoles();
filldropdown();
txtRoleName.Text = "";
txtloanrequestlimit.Text = "";
txtloanapprovallimit.Text = "";
txtLoanDisbursementLimit.Text = "";
txtExpenseLimit.Text = "";
//For Bank Limit edited by :kamal thapa
txtBankLimit.Text = "";
btnRole.CommandName = "Save";
}
else
{
msgbox.ShowWarning(msg);
}
btnRole.Text = "Save";
}
else
{
msgbox.ShowWarning("Role Name Is Mandatory");
}
}
private void FillgvRoles()
{
var dt = new DataTable();
dt = BL_Roles.GetRoles(1, 0, "");
if (dt.Rows.Count > 0)
{
gvUsersRoles.DataSource = dt;
gvUsersRoles.DataBind();
}
else
{
gvUsersRoles.DataSource = new string[] { };
gvUsersRoles.DataBind();
}
}
#endregion
#region Menu Assign
protected void filldropdown()
{
ddlMainMenu = FillDropDown.FillddlMainMenu(ddlMainMenu, 1, 0, "");
ddlRoleName = FillDropDown.FillddlRoles(ddlRoleName, 1, 0, "");
}
protected void FillGrid()
{
var dt = new DataTable();
dt = BL_ChildMenu.GetChildMenu(2, Convert.ToInt32(ddlMainMenu.SelectedValue), ddlRoleName.SelectedValue);
if (dt.Rows.Count > 0)
{
gvAllMenu.DataSource = dt;
gvAllMenu.DataBind();
}
else
{
gvAllMenu.DataSource = new string[] { };
gvAllMenu.DataBind();
}
dt = BL_MenuAssign.GetMenuAssign(1, Convert.ToInt32(ddlMainMenu.SelectedValue), 0, ddlRoleName.SelectedValue);
if (dt.Rows.Count > 0)
{
gvAssignedMenu.DataSource = dt;
gvAssignedMenu.DataBind();
}
else
{
gvAssignedMenu.DataSource = dt;
gvAssignedMenu.DataBind();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
int j = 0;
foreach (GridViewRow gr in gvAllMenu.Rows)
{
var hdChildMenuID = (HiddenField)gr.FindControl("hdChildMenuID");
var chkTransfer = (CheckBox)gr.FindControl("chkMenu");
var st = new BL_MenuAssign();
if (chkTransfer.Checked)
{
st.EVENT = 'I';
st.ChildMenuID = int.Parse(hdChildMenuID.Value.ToString());
st.RoleID = Convert.ToInt32(ddlRoleName.SelectedValue.ToString());
st.MainMenuID = Convert.ToInt32(ddlMainMenu.SelectedValue.ToString());
int Id = 0;
st.InsUpdDelMenuAssign(out Id);
j++;
}
}
if (j > 0)
{
msgbox.ShowSuccess("Menu Granted");
BL_UserActivityLog.SaveSettingActivityLog("",
"Child Menu Assign By:" + ddlRoleName.SelectedItem.Text + "In Main Menu:" +
ddlMainMenu.SelectedItem.Text);
FillGrid();
// Response.Redirect("~/Admin/MenuAssign.aspx");
}
else
{
msgbox.ShowInfo("Please select child menu", 10, 400);
}
}
catch (Exception ex)
{
msgbox.ShowError(ex.Message, 10, 400);
}
}
protected void ddlRoleName_SelectedIndexChanged(object sender, EventArgs e)
{
FillGrid();
}
protected void ddlMainMenu_SelectedIndexChanged(object sender, EventArgs e)
{
FillGrid();
}
protected void gvAssignedMenu_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete1")
{
BL_MenuAssign obj = new BL_MenuAssign();
obj.EVENT = 'D';
obj.MainMenuID = 0;
obj.ChildMenuID = 0;
obj.ID = Convert.ToInt32(e.CommandArgument);
int Id = 0;
string msg = obj.InsUpdDelMenuAssign(out Id);
if (msg != "")
{
msgbox.ShowSuccess(msg);
FillGrid();
}
}
}
protected void gvUsersRoles_RowDataBound(object sender, GridViewRowEventArgs e)
{
//if (e.Row.RowType == DataControlRowType.Header)
//{
//}
if (e.Row.RowType == DataControlRowType.DataRow)
{
// var amount = Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "CurrentYear"));//Closing_Bal
//var prevAmt = Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "Closing_Bal1"));
// var lblpartAssets = (Label)e.Row.FindControl("lblIncome");
var lblLoanLimitAmt = (Label)e.Row.FindControl("lblLoanLimitAmt");
var lblExpenseLimitAmt = (Label)e.Row.FindControl("lblExpenseLimitAmt");
//For Bank Limit edited by :kamal thapa
var lblBankLimitAmt = (Label)e.Row.FindControl("lblBankLimitAmt");
if (lblLoanLimitAmt != null)
if (lblLoanLimitAmt.Text != "")
TextFormatting.RemoveZerroForLabel(lblLoanLimitAmt);
if (lblExpenseLimitAmt != null)
if (lblExpenseLimitAmt.Text != "")
TextFormatting.RemoveZerroForLabel(lblExpenseLimitAmt);
//For Bank Limit edited by :kamal thapa
if (lblBankLimitAmt != null)
{
if (lblBankLimitAmt.Text != "")
{
TextFormatting.RemoveZerroForLabel(lblBankLimitAmt);
}
}
}
}
#endregion
protected void gvAllMenu_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
try
{
if (gvAllMenu.PageCount <= e.NewPageIndex)
{
gvAllMenu.PageIndex = 0;
}
else
{
gvAllMenu.PageIndex = e.NewPageIndex;
}
this.FillGrid();
}
catch (Exception ex)
{
msgbox.ShowError(ex.Message);
}
}
}
Comments
Post a Comment