protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
#region DELETE
if (HfSR_NO.Value != string.Empty)
{
string str = ACCOUNTS_DETLogicLayer.DeleteACCOUNTS_DETDetailsByID(HfSR_NO.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(HfACODE.Value);
UserRights();
}
#endregion
}
catch (Exception)
{
throw;
}
}
public void FillGrid(string Acode)
{
try
{
DataTable Dt = new DataTable();
Dt = ACCOUNTS_DETLogicLayer.GetAllACCOUNTS_DETDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));
DataView Dv = new DataView(Dt);
if (Acode != string.Empty)
{
Dv.RowFilter = "ACODE=" + HfACODE.Value;
}
DtSearch = Dv.ToTable();
GvAccContact.DataSource = Dv.ToTable();
GvAccContact.DataBind();
}
catch (Exception)
{
throw;
}
}
protected void GvAccContact_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Deletea")
{
#region DELETE
clear();
DataTable dt = ACCOUNTS_DETLogicLayer.GetAllIDWiseACCOUNTS_DETDetials(e.CommandArgument.ToString());
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
if (HfCompCode.Value == string.Empty && HfACODE.Value == string.Empty)
{
if (DdlAccountName.SelectedIndex != 0)
{
HfACODE.Value = DdlAccountName.SelectedValue;
}
//if (DdlComapnyName.SelectedIndex != 0)
//{
// HfCompCode.Value = DdlComapnyName.SelectedValue;
//}
//HfCompCode.Value = Session["COMP_CODE"].ToString();
}
FillDdlCompanyName();
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
FillDdlAccountName();
DdlAccountName.SelectedValue = dt.Rows[0]["ACODE"].ToString();
HfSR_NO.Value = dt.Rows[0]["SRNO"].ToString();
TxtContactName.Text = dt.Rows[0]["CONTACT_NAME"].ToString();
TxtDesignation.Text = dt.Rows[0]["DESIGN_NAME"].ToString();
TxtMobileNo.Text = dt.Rows[0]["PHONE_NO"].ToString();
TxtEmailAddress.Text = dt.Rows[0]["MAIL_ID"].ToString();
TxtDob.Text = Convert.ToDateTime(dt.Rows[0]["DOB"].ToString()).ToString("MM-dd-yyyy");
if (dt.Rows[0]["ACC_FLAG"].ToString() == "Y")
{
Chk_Accounts.Checked = true;
}
else
{
Chk_Accounts.Checked = false;
}
if (dt.Rows[0]["GEN_FLAG"].ToString() == "Y")
{
Chk_General.Checked = true;
}
else
{
Chk_General.Checked = false;
}
if (dt.Rows[0]["OWNER_FLAG"].ToString() == "Y")
{
Chk_Owner.Checked = true;
}
else
{
Chk_Owner.Checked = false;
}
if (dt.Rows[0]["PUR_FLAG"].ToString() == "Y")
{
Chk_Purchase.Checked = true;
}
else
{
Chk_Purchase.Checked = false;
}
if (dt.Rows[0]["SERVICE_FLAG"].ToString() == "Y")
{
Chk_Service.Checked = true;
}
else
{
Chk_Service.Checked = false;
}
if (dt.Rows[0]["SMS_FLAG"].ToString() == "Y")
{
Chk_SMS.Checked = true;
}
else
{
Chk_SMS.Checked = false;
}
DdlActive.SelectedValue = dt.Rows[0]["ACTIVE"].ToString();
TxtRemarks.Text = dt.Rows[0]["REMARK"].ToString();
}
btnSave.Visible = false;
btnDelete.Visible = true;
Btncalldel.Visible = true;
BtncallUpd.Visible = false;
ControllerDisable();
#endregion
}
if (e.CommandName == "Edita")
{
#region EDIT
clear();
DataTable dt = ACCOUNTS_DETLogicLayer.GetAllIDWiseACCOUNTS_DETDetials(e.CommandArgument.ToString());
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
if (HfCompCode.Value == string.Empty && HfACODE.Value == string.Empty)
{
if (DdlAccountName.SelectedIndex != 0)
{
HfACODE.Value = DdlAccountName.SelectedValue;
}
//if (DdlComapnyName.SelectedIndex != 0)
//{
// HfCompCode.Value = DdlComapnyName.SelectedValue;
//}
}
FillDdlCompanyName();
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
FillDdlAccountName();
DdlAccountName.SelectedValue = dt.Rows[0]["ACODE"].ToString();
HfSR_NO.Value = dt.Rows[0]["SRNO"].ToString();
TxtContactName.Text = dt.Rows[0]["CONTACT_NAME"].ToString();
TxtDesignation.Text = dt.Rows[0]["DESIGN_NAME"].ToString();
TxtMobileNo.Text = dt.Rows[0]["PHONE_NO"].ToString();
TxtEmailAddress.Text = dt.Rows[0]["MAIL_ID"].ToString();
TxtDob.Text = Convert.ToDateTime(dt.Rows[0]["DOB"].ToString()).ToString("MM-dd-yyyy");
if (dt.Rows[0]["ACC_FLAG"].ToString() == "Y")
{
Chk_Accounts.Checked = true;
}
else
{
Chk_Accounts.Checked = false;
}
if (dt.Rows[0]["GEN_FLAG"].ToString() == "Y")
{
Chk_General.Checked = true;
}
else
{
Chk_General.Checked = false;
}
if (dt.Rows[0]["OWNER_FLAG"].ToString() == "Y")
{
Chk_Owner.Checked = true;
}
else
{
Chk_Owner.Checked = false;
}
if (dt.Rows[0]["PUR_FLAG"].ToString() == "Y")
{
Chk_Purchase.Checked = true;
}
else
{
Chk_Purchase.Checked = false;
}
if (dt.Rows[0]["SERVICE_FLAG"].ToString() == "Y")
{
Chk_Service.Checked = true;
}
else
{
Chk_Service.Checked = false;
}
if (dt.Rows[0]["SMS_FLAG"].ToString() == "Y")
{
Chk_SMS.Checked = true;
}
else
{
Chk_SMS.Checked = false;
}
DdlActive.SelectedValue = dt.Rows[0]["ACTIVE"].ToString();
TxtRemarks.Text = dt.Rows[0]["REMARK"].ToString();
BtncallUpd.Text = "UPDATE";
#endregion
}
#region CHECK UPDATE RIGHTS
if (Session["UPDATE"] != null)
{
if (Session["UPDATE"].ToString() == "Y")
{
ControllerEnable();
}
else
{
ControllerDisable();
}
}
#endregion
Btncalldel.Visible = false;
BtncallUpd.Visible = true;
btnSave.Visible = true;
DdlAccountName.Enabled = false;
UserRights();
}
if (e.CommandName == "Viewa")
{
#region SET TEXT ON VIEW
clear();
DataTable dt = ACCOUNTS_DETLogicLayer.GetAllIDWiseACCOUNTS_DETDetials(e.CommandArgument.ToString());
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
if (HfCompCode.Value == string.Empty && HfACODE.Value == string.Empty)
{
if (DdlAccountName.SelectedIndex != 0)
{
HfACODE.Value = DdlAccountName.SelectedValue;
}
//if (DdlComapnyName.SelectedIndex != 0)
//{
// HfCompCode.Value = DdlComapnyName.SelectedValue;
//}
}
FillDdlCompanyName();
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
FillDdlAccountName();
DdlAccountName.SelectedValue = dt.Rows[0]["ACODE"].ToString();
HfSR_NO.Value = dt.Rows[0]["SRNO"].ToString();
TxtContactName.Text = dt.Rows[0]["CONTACT_NAME"].ToString();
TxtDesignation.Text = dt.Rows[0]["DESIGN_NAME"].ToString();
TxtMobileNo.Text = dt.Rows[0]["PHONE_NO"].ToString();
TxtEmailAddress.Text = dt.Rows[0]["MAIL_ID"].ToString();
TxtDob.Text = Convert.ToDateTime(dt.Rows[0]["DOB"].ToString()).ToString("MM-dd-yyyy");
if (dt.Rows[0]["ACC_FLAG"].ToString() == "Y")
{
Chk_Accounts.Checked = true;
}
else
{
Chk_Accounts.Checked = false;
}
if (dt.Rows[0]["GEN_FLAG"].ToString() == "Y")
{
Chk_General.Checked = true;
}
else
{
Chk_General.Checked = false;
}
if (dt.Rows[0]["OWNER_FLAG"].ToString() == "Y")
{
Chk_Owner.Checked = true;
}
else
{
Chk_Owner.Checked = false;
}
if (dt.Rows[0]["PUR_FLAG"].ToString() == "Y")
{
Chk_Purchase.Checked = true;
}
else
{
Chk_Purchase.Checked = false;
}
if (dt.Rows[0]["SERVICE_FLAG"].ToString() == "Y")
{
Chk_Service.Checked = true;
}
else
{
Chk_Service.Checked = false;
}
if (dt.Rows[0]["SMS_FLAG"].ToString() == "Y")
{
Chk_SMS.Checked = true;
}
else
{
Chk_SMS.Checked = false;
}
DdlActive.SelectedValue = dt.Rows[0]["ACTIVE"].ToString();
TxtRemarks.Text = dt.Rows[0]["REMARK"].ToString();
#endregion
}
ControllerDisable();
btnSave.Visible = false;
Btncalldel.Visible = false;
BtncallUpd.Visible = false;
UserRights();
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message.ToString();
}
}
protected void BtncallUpd_Click(object sender, EventArgs e)
{
try
{
if (BtncallUpd.Text == "UPDATE")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true);
}
else
{
#region SAVE
if (HfACODE.Value == string.Empty)
{
if (DdlAccountName.SelectedIndex != 0)
{
HfACODE.Value = DdlAccountName.SelectedValue;
}
//if (DdlComapnyName.SelectedIndex != 0)
//{
// HfCompCode.Value = DdlComapnyName.SelectedValue;
//}
}
if (HfCompCode.Value == string.Empty)
{
HfCompCode.Value = Session["COMP_CODE"].ToString();
}
// HfCompCode.Value = DdlComapnyName.SelectedValue;
// HfACODE.Value = DdlAccountName.SelectedValue;
if (HfCompCode.Value != string.Empty && HfACODE.Value != string.Empty)
{
ACCOUNTS_DETLogicLayer insert = new ACCOUNTS_DETLogicLayer();
insert.COMP_CODE = HfCompCode.Value.Trim();
insert.ACODE = HfACODE.Value.Trim();
insert.SRNO = HfSR_NO.Value.Trim();
insert.CONTACT_NAME = TxtContactName.Text.Trim().ToUpper();
insert.DESIGN_NAME = TxtDesignation.Text.Trim().ToUpper();
insert.PHONE_NO = TxtMobileNo.Text.Trim().ToUpper();
insert.MAIL_ID = TxtEmailAddress.Text.Trim();
insert.ACTIVE = DdlActive.SelectedValue.Trim().ToUpper();
if (TxtDob.Text == string.Empty)
{
insert.DOB = "";
}
else
{
insert.DOB = Convert.ToDateTime(TxtDob.Text.Trim().ToUpper()).ToString("MM-dd-yyyy");
}
if (Chk_Accounts.Checked == true)
{
insert.ACC_FLAG = "Y";
}
else
{
insert.ACC_FLAG = "N";
}
if (Chk_Purchase.Checked == true)
{
insert.PUR_FLAG = "Y";
}
else
{
insert.PUR_FLAG = "N";
}
if (Chk_Service.Checked == true)
{
insert.SERVICE_FLAG = "Y";
}
else
{
insert.SERVICE_FLAG = "N";
}
if (Chk_Owner.Checked == true)
{
insert.OWNER_FLAG = "Y";
}
else
{
insert.OWNER_FLAG = "N";
}
if (Chk_General.Checked == true)
{
insert.GEN_FLAG = "Y";
}
else
{
insert.GEN_FLAG = "N";
}
if (Chk_SMS.Checked == true)
{
insert.SMS_FLAG = "Y";
}
else
{
insert.SMS_FLAG = "N";
}
insert.REMARK = TxtRemarks.Text.Trim().ToUpper();
insert.INS_USERID = Session["USERNAME"].ToString();
insert.INS_TERMINAL = Session["PC"].ToString();
insert.INS_DATE = "";
insert.UPD_USERID = Session["USERNAME"].ToString();
insert.UPD_TERMINAL = Session["PC"].ToString();
insert.UPD_DATE = "";
if (BtncallUpd.Text.Trim().ToUpper() == "SAVE")
{
string str = ACCOUNTS_DETLogicLayer.InsertACCOUNTS_DETDetail(insert);
if (str.Contains("successfully"))
{
lblmsg.Text = "CONTACT DETAIL ADD SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillGrid(HfACODE.Value);
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "CONTACT CODE ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : CONTACT DETAIL NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
#endregion
}
}
}
catch (Exception)
{
throw;
}
}
