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