protected void GridBranch_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("HfBranch_Code") as HiddenField);
DataTable Dt = new DataTable();
string USERCODE = DdlUser.SelectedValue;
string COMPANYCODE = DdlCompany.SelectedValue;
// string brachCode = HfBranch_Code.Value;
Dt = BRANCH_MASLogicLayer.GetBranchDetailUserWiseRightsAndCompanyWise(USERCODE, COMPANYCODE);
for (int i = 0; i < Dt.Rows.Count; i++)
{
if (HfId.Value == Dt.Rows[i]["BRANCH_CODE"].ToString())
{
btn.Enabled = false;
}
}
}
}
catch (Exception)
{
throw;
}
}
public void FillToBranchOnUpdate(string Id)
{
try
{
string Comp_Code = HfCompCode.Value.Trim();
DataTable Dt = new DataTable();
Dt = BRANCH_MASLogicLayer.GetBranchDetailCompanyWiseFor_Ddl(Comp_Code);
if (HfToBranchCode.Value.ToString() != "0")
{
DataView Dv = new DataView(Dt);
Dv.RowFilter = "BRANCH_CODE=" + Id;
DataTable DtView = Dv.ToTable();
TxtToBranch.Text = DtView.Rows[0]["BRANCH_NAME"].ToString();
HfToBranchCode.Value = DtView.Rows[0]["BRANCH_CODE"].ToString();
}
}
catch (Exception)
{
throw;
}
}
protected void GridBranch_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Adda")
{
string str = BRANCH_MASLogicLayer.InsertUSER_BRANCHDetail(e.CommandArgument.ToString(), DdlUser.SelectedValue.ToString(), DdlCompany.SelectedValue.ToString());
if (str.Contains("successfully"))
{
lblmsg.Text = "BRANCH ADD SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "BRANCH ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : BRANCH NOT ASSIGNED";
lblmsg.ForeColor = Color.Red;
}
}
}
catch (Exception)
{
throw;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
#region DELETE - MIHIR LAD 04-10-2018
if (HfBRANCH_CODE.Value != string.Empty)
{
string str = BRANCH_MASLogicLayer.DeleteBRANCHDetailsByID(HfBRANCH_CODE.Value);
if (str.Contains("successfully"))
{
lblmsg.Text = "Record Deleted Successfully";
lblmsg.ForeColor = Color.Green;
}
else if (str.Contains("Cannot"))
{
lblmsg.Text = "Cannot Delete This Record It Used by Other Data";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "Error:Branch Not Deleted";
lblmsg.ForeColor = Color.Red;
}
clear();
FillGrid(HfCompCode.Value);
UserRights();
}
#endregion
}
catch (Exception)
{
throw;
}
}
protected void chkBranch_OnCheckedChanged(object sender, EventArgs e)
{
try
{
int selRowIndex = ((GridViewRow)(((CheckBox)sender).Parent.Parent)).RowIndex;
CheckBox cb = (CheckBox)GridBranch.Rows[selRowIndex].FindControl("chkBranch");
HiddenField BranchCode = (HiddenField)GridBranch.Rows[selRowIndex].FindControl("HfBranch_Code");
if (cb.Checked)
{
//ADD
string str = BRANCH_MASLogicLayer.InsertUSER_BRANCHDetail(BranchCode.Value, DdlUser.SelectedValue.ToString(), DdlCompany.SelectedValue.ToString());
if (str.Contains("successfully"))
{
lblmsg.Text = "BRANCH ADD SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "BRANCH ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : BRANCH NOT ASSIGNED";
lblmsg.ForeColor = Color.Red;
}
}
else
{
//REMOVE
string str = BRANCH_MASLogicLayer.DELETEUSER_BRANCHDetail(BranchCode.Value, DdlUser.SelectedValue.ToString(), DdlCompany.SelectedValue.ToString());
if (str.Contains("successfully"))
{
lblmsg.Text = "BRANCH REMOVE SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "BRANCH ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : BRANCH NOT REMOVED";
lblmsg.ForeColor = Color.Red;
}
}
FillGridBranch();
}
catch (Exception)
{
throw;
}
}
public void FillGridBranch()
{
try
{
DataTable Dt = new DataTable();
string COMPANYCODE = DdlCompany.SelectedValue;
Dt = BRANCH_MASLogicLayer.GetBranchDetailCompanyWise(COMPANYCODE);
GridBranch.DataSource = Dt;
GridBranch.DataBind();
}
catch (Exception)
{
throw;
}
}
public void FillBranch(string CompCode)
{
try
{
DataTable Dt = BRANCH_MASLogicLayer.GetBranchDetailUserWiseRightsAndCompanyWise(Session["USERCODE"].ToString(), CompCode);
DdlBranch.DataSource = Dt;
DdlBranch.DataValueField = "BRANCH_CODE";
DdlBranch.DataTextField = "BRANCH_NAME";
DdlBranch.DataBind();
}
catch (Exception)
{
throw;
}
}
private void GetBranchBySelectedCompany()
{
try
{
DataTable Dt = new DataTable();
string USERCODE = DdlUser.SelectedValue;
string COMPANYCODE = DdlCompany.SelectedValue;
Dt = BRANCH_MASLogicLayer.GetBranchDetailUserWiseRightsAndCompanyWise(USERCODE, COMPANYCODE);
GridBranch.DataSource = Dt;
GridBranch.DataBind();
}
catch (Exception)
{
throw;
}
}
public void FillDdlBranchOnBranchCode()
{
try
{
DataTable Dt = new DataTable();
Dt = BRANCH_MASLogicLayer.GetAllIDWiseBRANCH_MASDetials(Branchcode);
DdlBranch.DataSource = Dt;
DdlBranch.DataValueField = "BRANCH_CODE";
DdlBranch.DataTextField = "BRANCH_NAME";
DdlBranch.DataBind();
}
catch (Exception)
{
throw;
}
}
private void GetBranchByCompany()
{
try
{
string selectedUser = DdlUser.SelectedValue;
string selectedCompany = DdlCompany.SelectedValue;
DataTable Dt = BRANCH_MASLogicLayer.GetBranchDetailUserWiseRightsAndCompanyWise(selectedUser, selectedCompany);
DdlBranch.DataSource = Dt;
DdlBranch.DataTextField = "BRANCH_NAME";
DdlBranch.DataValueField = "BRANCH_CODE";
DdlBranch.DataBind();
}
catch (Exception)
{
throw;
}
}
public void FillDdlBranchOnCompCode()
{
try
{
DataTable Dt = new DataTable();
Dt = BRANCH_MASLogicLayer.GetBranchDetailCompanyWiseFor_Ddl(compcode);
DdlBranch.DataSource = Dt;
DdlBranch.DataValueField = "BRANCH_CODE";
DdlBranch.DataTextField = "BRANCH_NAME";
DdlBranch.DataBind();
DdlBranch.SelectedValue = Session["BRANCH_CODE"].ToString();
}
catch (Exception)
{
throw;
}
}
public void FillDdlBranch()
{
try
{
DataTable Dt = new DataTable();
HfCompCode.Value = Session["COMP_CODE"].ToString();
string COMPANYCODE = HfCompCode.Value;
Dt = BRANCH_MASLogicLayer.GetBranchDetailCompanyWiseFor_Ddl(COMPANYCODE);
DdlBranch.DataSource = Dt;
DdlBranch.DataValueField = "BRANCH_CODE";
DdlBranch.DataTextField = "BRANCH_NAME";
DdlBranch.DataBind();
}
catch (Exception)
{
throw;
}
}
public void FillGrid(string CompCode)
{
try
{
HfCompCode.Value = Session["COMP_CODE"].ToString();
DataTable Dt = new DataTable();
Dt = BRANCH_MASLogicLayer.GetAllBRANCH_MASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));
DataView Dv = new DataView(Dt);
if (CompCode != string.Empty)
{
Dv.RowFilter = "COMP_CODE=" + HfCompCode.Value;
}
GvBranch.DataSource = Dv.ToTable();
GvBranch.DataBind();
}
catch (Exception)
{
throw;
}
}
public string GetBranchList()
{
#region CSV_FOR BRANCH
string CSV_BRANCHCODE = "";
if (DdlBranch.SelectedIndex == 0)
{
DataTable DtAllBranch = new DataTable();
DtAllBranch = BRANCH_MASLogicLayer.GetBranchNameCompanyWiseFor_DdlReport(compcode);
for (int i = 0; i < DtAllBranch.Rows.Count; i++)
{
string Ids = DtAllBranch.Rows[i]["BRANCH_CODE"].ToString();
if (Ids != string.Empty && Ids != null && Ids != "0")
{
if (CSV_BRANCHCODE != string.Empty)
{
CSV_BRANCHCODE = CSV_BRANCHCODE + "," + Ids;//,2,3,4
}
else
{
CSV_BRANCHCODE = CSV_BRANCHCODE + Ids;
}
}
}
}
else
{
CSV_BRANCHCODE = DdlBranch.SelectedValue.ToString();//Single Value
}
#endregion
return(CSV_BRANCHCODE);
}
protected void BtncallUpd_Click(object sender, EventArgs e)
{
try
{
if (BtncallUpd.Text == "UPDATE")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true);
}
else
{
HfCompCode.Value = Session["COMP_CODE"].ToString();
BRANCH_MASLogicLayer insert = new BRANCH_MASLogicLayer();
// insert.BRANCH_CODE = TxtBranchCode.Text.Trim().ToUpper(); ;
insert.BRANCH_CODE = HfBRANCH_CODE.Value.Trim();
insert.AUTO_MAILID = TxtBranchAutoEmailAddress.Text.Trim();
insert.BRANCH_ADD1 = TxtBranchAddress1.Text.Trim().ToUpper();
insert.BRANCH_ADD2 = TxtBranchAddress2.Text.Trim().ToUpper();
insert.BRANCH_ADD3 = TxtBranchAddress3.Text.Trim().ToUpper();
insert.BRANCH_EMAIL = TxtBranchEmailAddress.Text.Trim();
insert.BRANCH_FAX = TxtBranchFax.Text.Trim().Trim().ToUpper();
insert.BRANCH_NAME = TxtBranchName.Text.Trim().ToUpper();
insert.BRANCH_PHONE = TxtBranchPhoneNo.Text.Trim().ToUpper();
insert.BRANCH_SHORT = TxtBranchShort.Text.Trim().ToUpper();;
insert.BRANCH_TYPE = DdlBranchType.SelectedValue.Trim().ToUpper();
insert.BS_CRACODE = DdlBranchServiceCreditAC.SelectedValue.Trim().ToUpper();
insert.BS_DRACODE = DdlBranchServiceDebitAC.SelectedValue.Trim().ToUpper();
insert.COMP_CODE = HfCompCode.Value;
insert.CRACODE1 = DdlCreditExpenseACName1.SelectedValue.Trim().ToUpper();
insert.CRACODE2 = DdlCreditExpenseACName2.SelectedValue.Trim().ToUpper();
insert.CRACODE3 = DdlCreditExpenseACName3.SelectedValue.Trim().ToUpper();
insert.DRACODE1 = DdlDebitExpenseACName1.SelectedValue.Trim().ToUpper();
insert.DRACODE2 = DdlDebitExpenseACName2.SelectedValue.Trim().ToUpper();
insert.DRACODE3 = DdlDebitExpenseACName3.SelectedValue.Trim().ToUpper();
insert.INS_USERID = Session["USERNAME"].ToString();
insert.INS_TERMINAL = Session["PC"].ToString();
insert.INS_DATE = string.Empty;
insert.UPD_TERMINAL = Session["PC"].ToString();
insert.UPD_USERID = Session["USERNAME"].ToString();
insert.UPD_DATE = string.Empty;
insert.BRANCH_STATE = TxtBranchState.Text.Trim().ToUpper();
insert.BRANCH_STATE_NO = TxtBranchStateNo.Text.Trim();
insert.GST_APP_FLAG = DdlGSTAppllicableFlag.SelectedValue.Trim().ToUpper();
if (TxtGstAppDate.Text == string.Empty)
{
insert.GST_APP_DATE = "";
}
else
{
insert.GST_APP_DATE = Convert.ToDateTime(TxtGstAppDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy");
}
insert.BRANCH_GST_NO = TxtBranchGSTNo.Text.Trim().ToUpper();
insert.BRANCH_PARTY_TYPE = "";
insert.BRANCH_CITY = TxtCity.Text.Trim().ToUpper();
insert.BR_DRACODE = DdlBranchReceivedDebitAC.Text.Trim().ToUpper();
insert.BR_CRACODE = DdlBranchReceivedCreditAC.Text.Trim().ToUpper();
if (BtncallUpd.Text.Trim().ToUpper() == "SAVE")
{
string str = BRANCH_MASLogicLayer.InsertBRANCH_MASDetials(insert);
if (str.Contains("successfully"))
{
lblmsg.Text = "BRANCH DETAIL ADD SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillGrid(HfCompCode.Value);
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "BRANCH CODE ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : BRANCH DETAIL NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
}
}
catch (Exception)
{
throw;
}
}
protected void GvBranch_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Deletea")
{
#region EDIT
clear();
DataTable dt = BRANCH_MASLogicLayer.GetAllIDWiseBRANCH_MASDetials(e.CommandArgument.ToString());
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
// TxtBranchCode.Text = dt.Rows[0]["BRANCH_CODE"].ToString();
HfBRANCH_CODE.Value = dt.Rows[0]["BRANCH_CODE"].ToString();
TxtBranchName.Text = dt.Rows[0]["BRANCH_NAME"].ToString();
TxtBranchShort.Text = dt.Rows[0]["BRANCH_SHORT"].ToString();
DdlBranchType.SelectedValue = dt.Rows[0]["BRANCH_TYPE"].ToString();
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfBRANCH_CODE.Value = e.CommandArgument.ToString();
TxtBranchAddress1.Text = dt.Rows[0]["BRANCH_ADD1"].ToString();
TxtBranchAddress2.Text = dt.Rows[0]["BRANCH_ADD2"].ToString();
TxtBranchAddress3.Text = dt.Rows[0]["BRANCH_ADD3"].ToString();
TxtBranchEmailAddress.Text = dt.Rows[0]["BRANCH_EMAIL"].ToString();
TxtBranchAutoEmailAddress.Text = dt.Rows[0]["AUTO_MAILID"].ToString();
TxtBranchPhoneNo.Text = dt.Rows[0]["BRANCH_PHONE"].ToString();
TxtBranchFax.Text = dt.Rows[0]["BRANCH_FAX"].ToString();
DdlCreditExpenseACName1.SelectedValue = dt.Rows[0]["CRACODE1"].ToString();
DdlCreditExpenseACName2.SelectedValue = dt.Rows[0]["CRACODE2"].ToString();
DdlCreditExpenseACName3.SelectedValue = dt.Rows[0]["CRACODE3"].ToString();
DdlDebitExpenseACName1.SelectedValue = dt.Rows[0]["DRACODE1"].ToString();
DdlDebitExpenseACName2.SelectedValue = dt.Rows[0]["DRACODE2"].ToString();
DdlDebitExpenseACName3.SelectedValue = dt.Rows[0]["DRACODE3"].ToString();
DdlBranchServiceCreditAC.SelectedValue = dt.Rows[0]["BS_CRACODE"].ToString();
DdlBranchServiceDebitAC.SelectedValue = dt.Rows[0]["BS_DRACODE"].ToString();
TxtCity.Text = dt.Rows[0]["BRANCH_CITY"].ToString();
TxtBranchState.Text = dt.Rows[0]["BRANCH_STATE"].ToString();
TxtBranchStateNo.Text = dt.Rows[0]["BRANCH_STATE_NO"].ToString();
DdlGSTAppllicableFlag.SelectedValue = dt.Rows[0]["GST_APP_FLAG"].ToString();
TxtGstAppDate.Text = dt.Rows[0]["GST_APP_DATE"].ToString();
TxtBranchGSTNo.Text = dt.Rows[0]["BRANCH_GST_NO"].ToString();
DdlBranchReceivedCreditAC.SelectedValue = dt.Rows[0]["BR_CRACODE"].ToString();
DdlBranchReceivedDebitAC.SelectedValue = dt.Rows[0]["BR_DRACODE"].ToString();
// TxtCreatedBy.Text = dt.Rows[0]["INS_USERID"].ToString();
// TxtCreatedDate.Text = dt.Rows[0]["INS_DATE"].ToString();
// TxtUpdatedBy.Text = dt.Rows[0]["UPD_USERID"].ToString();
// TxtUpdatedDate.Text = dt.Rows[0]["UPD_DATE"].ToString();
}
btnSave.Visible = false;
btnDelete.Visible = true;
Btncalldel.Visible = true;
BtncallUpd.Visible = false;
ControllersDisable();
#endregion
}
if (e.CommandName == "Edita")
{
#region EDIT
clear();
DataTable dt = BRANCH_MASLogicLayer.GetAllIDWiseBRANCH_MASDetials(e.CommandArgument.ToString());
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
// TxtBranchCode.Text = dt.Rows[0]["BRANCH_CODE"].ToString();
HfBRANCH_CODE.Value = dt.Rows[0]["BRANCH_CODE"].ToString();
TxtBranchName.Text = dt.Rows[0]["BRANCH_NAME"].ToString();
TxtBranchShort.Text = dt.Rows[0]["BRANCH_SHORT"].ToString();
DdlBranchType.SelectedValue = dt.Rows[0]["BRANCH_TYPE"].ToString();
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfBRANCH_CODE.Value = e.CommandArgument.ToString();
TxtBranchAddress1.Text = dt.Rows[0]["BRANCH_ADD1"].ToString();
TxtBranchAddress2.Text = dt.Rows[0]["BRANCH_ADD2"].ToString();
TxtBranchAddress3.Text = dt.Rows[0]["BRANCH_ADD3"].ToString();
TxtBranchEmailAddress.Text = dt.Rows[0]["BRANCH_EMAIL"].ToString();
TxtBranchAutoEmailAddress.Text = dt.Rows[0]["AUTO_MAILID"].ToString();
TxtBranchPhoneNo.Text = dt.Rows[0]["BRANCH_PHONE"].ToString();
TxtBranchFax.Text = dt.Rows[0]["BRANCH_FAX"].ToString();
DdlCreditExpenseACName1.SelectedValue = dt.Rows[0]["CRACODE1"].ToString();
DdlCreditExpenseACName2.SelectedValue = dt.Rows[0]["CRACODE2"].ToString();
DdlCreditExpenseACName3.SelectedValue = dt.Rows[0]["CRACODE3"].ToString();
DdlDebitExpenseACName1.SelectedValue = dt.Rows[0]["DRACODE1"].ToString();
DdlDebitExpenseACName2.SelectedValue = dt.Rows[0]["DRACODE2"].ToString();
DdlDebitExpenseACName3.SelectedValue = dt.Rows[0]["DRACODE3"].ToString();
DdlBranchServiceCreditAC.SelectedValue = dt.Rows[0]["BS_CRACODE"].ToString();
DdlBranchServiceDebitAC.SelectedValue = dt.Rows[0]["BS_DRACODE"].ToString();
TxtCity.Text = dt.Rows[0]["BRANCH_CITY"].ToString();
TxtBranchState.Text = dt.Rows[0]["BRANCH_STATE"].ToString();
TxtBranchStateNo.Text = dt.Rows[0]["BRANCH_STATE_NO"].ToString();
DdlGSTAppllicableFlag.SelectedValue = dt.Rows[0]["GST_APP_FLAG"].ToString();
TxtGstAppDate.Text = dt.Rows[0]["GST_APP_DATE"].ToString();
TxtBranchGSTNo.Text = dt.Rows[0]["BRANCH_GST_NO"].ToString();
DdlBranchReceivedCreditAC.SelectedValue = dt.Rows[0]["BR_CRACODE"].ToString();
DdlBranchReceivedDebitAC.SelectedValue = dt.Rows[0]["BR_DRACODE"].ToString();
}
BtncallUpd.Text = "UPDATE";
// btnSave.Text = "UPDATE";
#endregion
#region CHECK UPDATE RIGHTS
if (Session["UPDATE"] != null)
{
if (Session["UPDATE"].ToString() == "Y")
{
ControllersEnable();
}
else
{
ControllersDisable();
}
}
#endregion
Btncalldel.Visible = false;
BtncallUpd.Visible = true;
btnSave.Visible = true;
UserRights();
}
if (e.CommandName == "Viewa")
{
#region SET TEXT ON VIEW
clear();
DataTable dt = BRANCH_MASLogicLayer.GetAllIDWiseBRANCH_MASDetials(e.CommandArgument.ToString());
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
// TxtBranchCode.Text = dt.Rows[0]["BRANCH_CODE"].ToString();
HfBRANCH_CODE.Value = dt.Rows[0]["BRANCH_CODE"].ToString();
TxtBranchName.Text = dt.Rows[0]["BRANCH_NAME"].ToString();
TxtBranchShort.Text = dt.Rows[0]["BRANCH_SHORT"].ToString();
DdlBranchType.SelectedValue = dt.Rows[0]["BRANCH_TYPE"].ToString();
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfBRANCH_CODE.Value = e.CommandArgument.ToString();
TxtBranchAddress1.Text = dt.Rows[0]["BRANCH_ADD1"].ToString();
TxtBranchAddress2.Text = dt.Rows[0]["BRANCH_ADD2"].ToString();
TxtBranchAddress3.Text = dt.Rows[0]["BRANCH_ADD3"].ToString();
TxtBranchEmailAddress.Text = dt.Rows[0]["BRANCH_EMAIL"].ToString();
TxtBranchAutoEmailAddress.Text = dt.Rows[0]["AUTO_MAILID"].ToString();
TxtBranchPhoneNo.Text = dt.Rows[0]["BRANCH_PHONE"].ToString();
TxtBranchFax.Text = dt.Rows[0]["BRANCH_FAX"].ToString();
DdlCreditExpenseACName1.SelectedValue = dt.Rows[0]["CRACODE1"].ToString();
DdlCreditExpenseACName2.SelectedValue = dt.Rows[0]["CRACODE2"].ToString();
DdlCreditExpenseACName3.SelectedValue = dt.Rows[0]["CRACODE3"].ToString();
DdlDebitExpenseACName1.SelectedValue = dt.Rows[0]["DRACODE1"].ToString();
DdlDebitExpenseACName2.SelectedValue = dt.Rows[0]["DRACODE2"].ToString();
DdlDebitExpenseACName3.SelectedValue = dt.Rows[0]["DRACODE3"].ToString();
DdlBranchServiceCreditAC.SelectedValue = dt.Rows[0]["BS_CRACODE"].ToString();
DdlBranchServiceDebitAC.SelectedValue = dt.Rows[0]["BS_DRACODE"].ToString();
TxtCity.Text = dt.Rows[0]["BRANCH_CITY"].ToString();
TxtBranchState.Text = dt.Rows[0]["BRANCH_STATE"].ToString();
TxtBranchStateNo.Text = dt.Rows[0]["BRANCH_STATE_NO"].ToString();
DdlGSTAppllicableFlag.SelectedValue = dt.Rows[0]["GST_APP_FLAG"].ToString();
TxtGstAppDate.Text = dt.Rows[0]["GST_APP_DATE"].ToString();
TxtBranchGSTNo.Text = dt.Rows[0]["BRANCH_GST_NO"].ToString();
DdlBranchReceivedCreditAC.SelectedValue = dt.Rows[0]["BR_CRACODE"].ToString();
DdlBranchReceivedDebitAC.SelectedValue = dt.Rows[0]["BR_DRACODE"].ToString();
// TxtCreatedBy.Text = dt.Rows[0]["INS_USERID"].ToString();
// TxtCreatedDate.Text = dt.Rows[0]["INS_DATE"].ToString();
// TxtUpdatedBy.Text = dt.Rows[0]["UPD_USERID"].ToString();
// TxtUpdatedDate.Text = dt.Rows[0]["UPD_DATE"].ToString();
#endregion
}
ControllersDisable();
btnSave.Visible = false;
Btncalldel.Visible = false;
BtncallUpd.Visible = false;
UserRights();
// btnDelete.Visible = true;
// btnSave.Text = "UPDATE";
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message.ToString();
}
}
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;
}
}
