protected void GridCompany_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow) { Button btn = (e.Row.FindControl("btnAdd") as Button); HiddenField HfId = (e.Row.FindControl("HfCOMP_CODE") as HiddenField); DataTable Dt = new DataTable(); string selectedUser = DdlUser.SelectedValue; Dt = COMPANYLogicLayer.GetCompanyDetailUserWiseRights(selectedUser); for (int i = 0; i < Dt.Rows.Count; i++) { if (HfId.Value == Dt.Rows[i]["COMP_CODE"].ToString()) { btn.Enabled = false; } } } } catch (Exception) { throw; } }
protected void GridYear_RowDataBound(object sender, GridViewRowEventArgs e) { try { if (e.Row.RowType == DataControlRowType.DataRow) { Button btn = (e.Row.FindControl("btnAdd") as Button); HiddenField HfId = (e.Row.FindControl("HfYRDT1") as HiddenField); DataTable Dt = new DataTable(); string USERCODE = DdlUser.SelectedValue; string COMPANYCODE = DdlCompany.SelectedValue; Dt = COMPANYLogicLayer.GetFIN_YEARSDetailUserWiseRightsAndCompanyWiseForGrid(USERCODE, COMPANYCODE); for (int i = 0; i < Dt.Rows.Count; i++) { if (HfId.Value == Dt.Rows[i]["YRDT1"].ToString()) { btn.Enabled = false; } } } } catch (Exception) { throw; } }
public void FillYear(string CompCode) { try { DataTable GetYear = COMPANYLogicLayer.GetAllFinancialYearDetials(CompCode); string Year = GetCurrentFinancialYear(); if (GetYear.Rows.Count > 0) { DataView DV = new DataView(GetYear); DV.RowFilter = "YRDT1='" + Year + "-04-01 00:00:00.000'"; DataTable DT = DV.ToTable(); if (DT.Rows.Count == 0) { string Ans = COMPANYLogicLayer.InsertFinancialYearDetials(CompCode, Year + "-04-01 00:00:00.000", (Convert.ToInt32(Year) + 1).ToString() + "-03-31 00:00:00.000"); } } DataTable Dt = COMPANYLogicLayer.GetFIN_YEARSDetailUserWiseRightsAndCompanyWise(ViewState["USERCODE"].ToString(), CompCode); DdlFinYear.DataSource = Dt; DdlFinYear.DataValueField = "YRDT1"; DdlFinYear.DataTextField = "YearString"; DdlFinYear.DataBind(); } catch (Exception) { throw; } }
protected void GridCompany_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Adda") { string str = COMPANYLogicLayer.InsertUSER_COMPANY_RIGHTSDetail(e.CommandArgument.ToString(), DdlUser.SelectedValue.ToString()); if (str.Contains("successfully")) { lblmsg.Text = "COMPANY ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "COMPANY ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : COMPANY NOT ASSIGNED"; lblmsg.ForeColor = Color.Red; } } } catch (Exception) { throw; } }
protected void chkFinYear_OnCheckedChanged(object sender, EventArgs e) { try { int selRowIndex = ((GridViewRow)(((CheckBox)sender).Parent.Parent)).RowIndex; CheckBox cb = (CheckBox)GridYear.Rows[selRowIndex].FindControl("chkFinYear"); HiddenField YearDate1 = (HiddenField)GridYear.Rows[selRowIndex].FindControl("HfYRDT1"); if (cb.Checked) { //ADD string str = COMPANYLogicLayer.InsertUSER_YEARS_RIGHTSDetail(DdlCompany.SelectedValue.ToString(), DdlUser.SelectedValue.ToString(), YearDate1.Value); if (str.Contains("successfully")) { lblmsg.Text = "YEAR ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "YEAR ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : YEAR NOT ASSIGNED"; lblmsg.ForeColor = Color.Red; } } else { //REMOVE string str = COMPANYLogicLayer.DELETEUSER_YEARS_RIGHTSDetail(DdlCompany.SelectedValue.ToString(), DdlUser.SelectedValue.ToString(), YearDate1.Value); if (str.Contains("successfully")) { lblmsg.Text = "YEAR REMOVED SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "YEAR ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : YEAR NOT REMOVED"; lblmsg.ForeColor = Color.Red; } } FillFinYears(); } catch (Exception) { throw; } }
protected void chkCompany_OnCheckedChanged(object sender, EventArgs e) { try { int selRowIndex = ((GridViewRow)(((CheckBox)sender).Parent.Parent)).RowIndex; CheckBox cb = (CheckBox)GridCompany.Rows[selRowIndex].FindControl("chkCompany"); HiddenField CompanyCode = (HiddenField)GridCompany.Rows[selRowIndex].FindControl("HfCOMP_CODE"); if (cb.Checked) { //ADD string str = COMPANYLogicLayer.InsertUSER_COMPANY_RIGHTSDetail(CompanyCode.Value, DdlUser.SelectedValue.ToString()); if (str.Contains("successfully")) { lblmsg.Text = "COMPANY ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "COMPANY ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : COMPANY NOT ASSIGNED"; lblmsg.ForeColor = Color.Red; } } else { //REMOVE string str = COMPANYLogicLayer.DELETEUSER_COMPANY_RIGHTSDetail(CompanyCode.Value, DdlUser.SelectedValue.ToString()); if (str.Contains("successfully")) { lblmsg.Text = "COMPANY REMOVE SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "COMPANY ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : COMPANY NOT REMOVED"; lblmsg.ForeColor = Color.Red; } } FillGridCompany(); } catch (Exception) { throw; } }
public void FillGridCompany() { try { DataTable Dt = new DataTable(); Dt = COMPANYLogicLayer.GetAllCOMPANYDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString())); GridCompany.DataSource = Dt; GridCompany.DataBind(); } catch (Exception) { throw; } }
protected void GridYear_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Adda") { string str = COMPANYLogicLayer.InsertUSER_YEARS_RIGHTSDetail(DdlCompany.SelectedValue.ToString(), DdlUser.SelectedValue.ToString(), e.CommandArgument.ToString()); if (str.Contains("successfully")) { lblmsg.Text = "YEAR ADD SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "YEAR ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : YEAR NOT ASSIGNED"; lblmsg.ForeColor = Color.Red; } } else if (e.CommandName == "Removea") { string str = COMPANYLogicLayer.DELETEUSER_YEARS_RIGHTSDetail(DdlCompany.SelectedValue.ToString(), DdlUser.SelectedValue.ToString(), e.CommandArgument.ToString()); if (str.Contains("successfully")) { lblmsg.Text = "YEAR REMOVED SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "YEAR ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR : YEAR NOT REMOVED"; lblmsg.ForeColor = Color.Red; } } FillFinYears(); } catch (Exception) { throw; } }
private void GetCompanyOfSelectedUser() { try { DataTable Dt = new DataTable(); string selectedUser = DdlUser.SelectedValue; Dt = COMPANYLogicLayer.GetCompanyDetailUserWiseRights(selectedUser); GridCompany.DataSource = Dt; GridCompany.DataBind(); } catch (Exception) { throw; } }
public void FillYear(string CompCode) { try { DataTable Dt = COMPANYLogicLayer.GetFIN_YEARSDetailUserWiseRightsAndCompanyWise(Session["USERCODE"].ToString(), CompCode); DdlFinYear.DataSource = Dt; DdlFinYear.DataValueField = "YRDT1"; DdlFinYear.DataTextField = "YearString"; DdlFinYear.DataBind(); } catch (Exception) { throw; } }
public void FillCompany() { try { DataTable Dt = COMPANYLogicLayer.GetCompanyDetailUserWiseRights(Session["USERCODE"].ToString()); DdlCompany.DataSource = Dt; DdlCompany.DataValueField = "COMP_CODE"; DdlCompany.DataTextField = "NAME"; DdlCompany.DataBind(); } catch (Exception) { throw; } }
public void FillFinYears() { try { DataTable Dt = new DataTable(); // string USERCODE = DdlUser.SelectedValue; string COMPANYCODE = DdlCompany.SelectedValue; Dt = COMPANYLogicLayer.GetAllFIN_YEARSDetialsForGrid(COMPANYCODE); GridYear.DataSource = Dt; GridYear.DataBind(); } catch (Exception) { throw; } }
private void GetComapnyByUser() { try { string selectedUser = DdlUser.SelectedValue; DataTable Dt = COMPANYLogicLayer.GetCompanyDetailUserWiseRights(selectedUser); DdlCompany.DataSource = Dt; DdlCompany.DataTextField = "NAME"; DdlCompany.DataValueField = "COMP_CODE"; DdlCompany.DataBind(); } catch (Exception) { throw; } }
public void FillDdlCompany() { try { DataTable dt = COMPANYLogicLayer.GetAllCOMPANYDetials_DDL(); DdlCompany.SelectedValue = Session["COMP_CODE"].ToString(); DdlCompany.DataSource = dt; DdlCompany.DataValueField = "COMP_CODE"; DdlCompany.DataTextField = "NAME"; DdlCompany.DataBind(); } catch (Exception) { throw; } }
private void GetFin_YearsByCompanyByUser() { try { DataTable Dt = new DataTable(); string USERCODE = DdlUser.SelectedValue; string COMPANYCODE = DdlCompany.SelectedValue; string BRANCHCODE = DdlBranch.SelectedValue; Dt = COMPANYLogicLayer.GetFIN_YEARSDetailUserWiseRightsAndCompanyWiseForGrid(USERCODE, COMPANYCODE); GridYear.DataSource = Dt; GridYear.DataBind(); } catch (Exception) { throw; } }
protected void BtnCompanyLogin_Click(object sender, EventArgs e) { try { Session["USERCODE"] = Session["USERCODE"].ToString(); Session["USERNAME"] = Session["USERNAME"].ToString(); Session["USERTYPE"] = Session["USERTYPE"].ToString(); Session["COMP_CODE"] = DdlCompany.SelectedValue; Session["COMP_NAME"] = DdlCompany.SelectedItem.Text; //Session["WORK_VIEWFLAG"] DataTable DtWorkFlag = COMPANYLogicLayer.GetCompanyDetailUserWiseRights(Session["USERCODE"].ToString()); if (DtWorkFlag.Rows.Count > 0) { DataView DvFlag = new DataView(DtWorkFlag); DvFlag.RowFilter = "COMP_CODE='" + Session["COMP_CODE"].ToString() + "'"; DataTable Dtflag = DvFlag.ToTable(); if (Dtflag.Rows.Count > 0) { Session["WORK_VIEWFLAG"] = Dtflag.Rows[0]["WORK_VIEWFLAG"].ToString(); } else { Session["WORK_VIEWFLAG"] = null; } } Session["BRANCH_CODE"] = DdlBranch.SelectedValue; Session["BRANCH_NAME"] = DdlBranch.SelectedItem.Text; DataTable dt = BRANCH_MASLogicLayer.GetIDWiseBRANCH_MASDetialsByCompany(Session["COMP_CODE"].ToString(), Session["BRANCH_CODE"].ToString()); if (dt.Rows.Count > 0) { Session["BRANCH_TYPE"] = dt.Rows[0]["BRANCH_TYPE"].ToString(); } Session["FIN_YEAR"] = DdlFinYear.SelectedValue;//YRDT1 Session["MAC"] = GetMACAddress(); Session["PC"] = GetMachinName(); Session["INSERT"] = "Y"; Session["UPDATE"] = "Y"; Session["DELETE"] = "Y"; DataTable Dt = COMPANYLogicLayer.GetFIN_YEARSDetailUserWiseRightsAndCompanyWise(Session["USERCODE"].ToString(), Session["COMP_CODE"].ToString()); if (Dt.Rows.Count > 0) { DataView Dv = new DataView(Dt); Dv.RowFilter = "YRDT1='" + Session["FIN_YEAR"].ToString() + "'"; DataTable DtV = Dv.ToTable(); if (DtV.Rows.Count > 0) { Session["FIN_YEAR_END"] = DtV.Rows[0]["YRDT2"].ToString(); } else { Session["FIN_YEAR_END"] = null; } } else { Session["FIN_YEAR_END"] = null; } USERLOGINLogicLayer insert = new USERLOGINLogicLayer(); insert.LCL_ID = Session["PC"].ToString(); insert.MAC_ID = Session["MAC"].ToString(); insert.USERNAME = Session["USERNAME"].ToString(); string str = USERLOGINLogicLayer.InsertUSERLOGINDetials(insert); if (!str.Contains("successfully")) { //Response.Redirect("../Login.aspx"); } Response.Redirect("/Admin/Dashboard.aspx", false); } catch (Exception) { throw; } }