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;
}
}
