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