protected void btnDelete_Click(object sender, EventArgs e)
{
try
{
#region DELETE
if (HfBrandTypeCode.Value != string.Empty)
{
string str = STOCK_BRANDTYPEMASLogicLayer.DeleteSTOCK_BRANDTYPEMASDetailsByID(HfBrandTypeCode.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:Stock Brand Type Master Not Deleted";
lblmsg.ForeColor = Color.Red;
}
clear();
FillStockBrandTypeMasterGrid(Session["COMP_CODE"].ToString());
UserRights();
}
#endregion
}
catch (Exception)
{
throw;
}
}
public void FillDdlBrandTypeName()
{
try
{
DataTable Dt = STOCK_BRANDTYPEMASLogicLayer.GetAllSTOCK_BRANDTYPEMASDetialsFor_DDL();
DdlBrandTypeName.DataSource = Dt;
DdlBrandTypeName.DataValueField = "BRANDTYPE_CODE";
DdlBrandTypeName.DataTextField = "BRANDTYPE_NAME";
DdlBrandTypeName.DataBind();
}
catch (Exception)
{
throw;
}
}
public void FillDdlModelTypeName()
{
try
{
string Comp_Code = Session["COMP_CODE"].ToString();
DataTable Dt = new DataTable();
Dt = STOCK_BRANDTYPEMASLogicLayer.GetSTOCK_BRANDTYPEMASCompanyWiseFor_Ddl(Comp_Code);
DdlModelTypeName.DataSource = Dt;
DdlModelTypeName.DataValueField = "BRANDTYPE_CODE";
DdlModelTypeName.DataTextField = "BRANDTYPE_NAME";
DdlModelTypeName.DataBind();
}
catch (Exception)
{
throw;
}
}
public void FillStockBrandTypeMasterGrid(string CompCode)
{
try
{
DataTable Dt = new DataTable();
Dt = STOCK_BRANDTYPEMASLogicLayer.GetAllSTOCK_BRANDTYEPMASDetials(Convert.ToInt32(Session["USERCODE"].ToString()), Convert.ToInt32(Session["COMP_CODE"].ToString()));
DataView Dv = new DataView(Dt);
if (CompCode != string.Empty)
{
Dv.RowFilter = "COMP_CODE=" + Session["COMP_CODE"].ToString();
}
GvStocktBrandTypeMaster.DataSource = Dv.ToTable();
GvStocktBrandTypeMaster.DataBind();
}
catch (Exception)
{
throw;
}
}
protected void BtncallUpd_Click(object sender, EventArgs e)
{
try
{
if (BtncallUpd.Text == "UPDATE")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModel1", "ShowModel1()", true);
}
else
{
#region INSERT STOCK BRAND TYPE MASTER
STOCK_BRANDTYPEMASLogicLayer insert = new STOCK_BRANDTYPEMASLogicLayer();
insert.COMP_CODE = Session["COMP_CODE"].ToString();
insert.BRANDTYPE_CODE = HfBrandTypeCode.Value.Trim();
insert.BRANDTYPE_NAME = TxtBrandTypeName.Text.Trim().ToUpper();
insert.BRANDTYPE_REMARK = "";
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 = "";
#endregion
#region INSERT STOCK BRAND TYPE DETAIL
XmlDocument XDoc1 = new XmlDocument();
XmlDeclaration dec1 = XDoc1.CreateXmlDeclaration("1.0", null, null);
XDoc1.AppendChild(dec1);// Create the root element
XmlElement root1 = XDoc1.CreateElement("root");
XDoc1.AppendChild(root1);
int SRNO_DET = 1;
foreach (GridViewRow row in GvStockBrandTypeDetail.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
HiddenField HfCompCodeVal = row.FindControl("HfCompCode") as HiddenField;
// HiddenField HfBrandTypeCode = row.FindControl("HfBrandTypeCode") as HiddenField;
// HiddenField HfSrNo = row.FindControl("HfSrNo") as HiddenField;
TextBox TxtWorkDescrition = row.FindControl("TxtWorkDescrition") as TextBox;
TextBox TxtRESULT_1_1 = row.FindControl("TxtRESULT_1_1") as TextBox;
TextBox TxtRESULT_1_2 = row.FindControl("TxtRESULT_1_2") as TextBox;
DropDownList DdlPrintFlag1 = row.FindControl("DdlPrintFlag1") as DropDownList;
TextBox TxtRESULT_2_1 = row.FindControl("TxtRESULT_2_1") as TextBox;
TextBox TxtRESULT_2_2 = row.FindControl("TxtRESULT_2_2") as TextBox;
DropDownList DdlPrintFlag2 = row.FindControl("DdlPrintFlag2") as DropDownList;
TextBox TxtRESULT_3_1 = row.FindControl("TxtRESULT_3_1") as TextBox;
TextBox TxtRESULT_3_2 = row.FindControl("TxtRESULT_3_2") as TextBox;
DropDownList DdlPrintFlag3 = row.FindControl("DdlPrintFlag3") as DropDownList;
XmlElement HandleDetail2 = XDoc1.CreateElement("Detail");
HandleDetail2.SetAttribute("SRNO", SRNO_DET.ToString());
HandleDetail2.SetAttribute("COMP_CODE", Session["COMP_CODE"].ToString());
// HandleDetail2.SetAttribute("BRANDTYPE_CODE", (HfBrandTypeCode.Value));
// HandleDetail2.SetAttribute("SRNO", (HfSrNo.Value));
HandleDetail2.SetAttribute("DESC_NAME", (TxtWorkDescrition.Text));
HandleDetail2.SetAttribute("RESULT_1_1", (TxtRESULT_1_1.Text));
HandleDetail2.SetAttribute("RESULT_1_2", (TxtRESULT_1_2.Text));
HandleDetail2.SetAttribute("PRINT_FLAG_1", (DdlPrintFlag1.SelectedValue));
HandleDetail2.SetAttribute("RESULT_2_1", (TxtRESULT_2_1.Text));
HandleDetail2.SetAttribute("RESULT_2_2", (TxtRESULT_2_2.Text));
HandleDetail2.SetAttribute("PRINT_FLAG_2", (DdlPrintFlag2.SelectedValue));
HandleDetail2.SetAttribute("RESULT_3_1", (TxtRESULT_3_1.Text));
HandleDetail2.SetAttribute("RESULT_3_2", (TxtRESULT_3_2.Text));
HandleDetail2.SetAttribute("PRINT_FLAG_3", (DdlPrintFlag3.SelectedValue));
HandleDetail2.SetAttribute("INS_USERID", (Session["USERNAME"].ToString()));
HandleDetail2.SetAttribute("INS_TERMINAL", (Session["PC"].ToString()));
HandleDetail2.SetAttribute("INS_DATE", (""));
HandleDetail2.SetAttribute("UPD_USERID", (Session["USERNAME"].ToString()));
HandleDetail2.SetAttribute("UPD_TERMINAL", (Session["PC"].ToString()));
HandleDetail2.SetAttribute("UPD_DATE", (""));
root1.AppendChild(HandleDetail2);
SRNO_DET++;
}
}
#endregion
string str = STOCK_BRANDTYPEMASLogicLayer.InsertSTOCK_BRANDTYPEMASDetail(insert, validation.RSC(XDoc1.OuterXml));
if (str.Contains("successfully"))
{
lblmsg.Text = "STOCK BRAND TYPE MASTER SAVE SUCCESSFULLY.";
lblmsg.ForeColor = Color.Green;
clear();
FillStockBrandTypeMasterGrid(Session["COMP_CODE"].ToString());
UserRights();
}
else if (str.Contains("Already") || str.Contains("PRIMARY KEY"))
{
lblmsg.Text = "STOCK BRAND TYPE MASTER ALREADY EXIST.";
lblmsg.ForeColor = Color.Red;
}
else
{
lblmsg.Text = "ERROR : STOCK BRAND TYPE MASTER NOT SAVED";
lblmsg.ForeColor = Color.Red;
}
}
}
catch (Exception)
{
throw;
}
}
protected void GvStocktBrandTypeMaster_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "Deletea")
{
#region DELETE
clear();
DataSet ds = STOCK_BRANDTYPEMASLogicLayer.GetAllIDWiseSTOCK_BRANDTYPEMASDetail(e.CommandArgument.ToString());
DataTable dt = ds.Tables[0];
DataTable dtBal = ds.Tables[1];
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfBrandTypeCode.Value = dt.Rows[0]["BRANDTYPE_CODE"].ToString();
// HfSrNo.Value = dt.Rows[0]["SRNO"].ToString();
TxtBrandTypeName.Text = dt.Rows[0]["BRANDTYPE_NAME"].ToString();
if (dtBal.Rows.Count > 0)
{
GvStockBrandTypeDetail.DataSource = dtBal;
GvStockBrandTypeDetail.DataBind();
}
}
btnSave.Visible = false;
btnDelete.Visible = true;
Btncalldel.Visible = true;
BtncallUpd.Visible = false;
BtnJobComplainMas.Enabled = true;
BtnBrandComplainMaster.Enabled = true;
BtnViewReports.Enabled = true;
ControllerDisable();
GvStockBrandTypeDetail.Enabled = false;
#endregion
}
if (e.CommandName == "Edita")
{
#region EDIT
clear();
DataSet ds = STOCK_BRANDTYPEMASLogicLayer.GetAllIDWiseSTOCK_BRANDTYPEMASDetail(e.CommandArgument.ToString());
DataTable dt = ds.Tables[0];
DataTable dtBal = ds.Tables[1];
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfBrandTypeCode.Value = dt.Rows[0]["BRANDTYPE_CODE"].ToString();
// HfSrNo.Value = dt.Rows[0]["SRNO"].ToString();
TxtBrandTypeName.Text = dt.Rows[0]["BRANDTYPE_NAME"].ToString();
ViewState["CurrentTable"] = dtBal;
if (dtBal.Rows.Count > 0)
{
GvStockBrandTypeDetail.DataSource = dtBal;
GvStockBrandTypeDetail.DataBind();
}
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;
BtnJobComplainMas.Enabled = true;
BtnBrandComplainMaster.Enabled = true;
BtnViewReports.Enabled = true;
UserRights();
GvStockBrandTypeDetail.Enabled = true;
}
if (e.CommandName == "Viewa")
{
#region SET TEXT ON VIEW
clear();
DataSet ds = STOCK_BRANDTYPEMASLogicLayer.GetAllIDWiseSTOCK_BRANDTYPEMASDetail(e.CommandArgument.ToString());
DataTable dt = ds.Tables[0];
DataTable dtBal = ds.Tables[1];
if (dt.Rows.Count > 0)
{
DivEntry.Visible = true;
DivView.Visible = false;
HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString();
HfBrandTypeCode.Value = dt.Rows[0]["BRANDTYPE_CODE"].ToString();
// HfSrNo.Value = dt.Rows[0]["SRNO"].ToString();
TxtBrandTypeName.Text = dt.Rows[0]["BRANDTYPE_NAME"].ToString();
if (dtBal.Rows.Count > 0)
{
GvStockBrandTypeDetail.DataSource = dtBal;
GvStockBrandTypeDetail.DataBind();
}
}
#endregion
ControllerDisable();
btnSave.Visible = false;
Btncalldel.Visible = false;
BtncallUpd.Visible = false;
BtnJobComplainMas.Enabled = true;
BtnBrandComplainMaster.Enabled = true;
BtnViewReports.Enabled = true;
UserRights();
GvStockBrandTypeDetail.Enabled = false;
}
}
catch (Exception ex)
{
lblmsg.Text = ex.Message.ToString();
}
}
