public void FillBRANCH_RECMAS_MasterGrid(string CompCode) { DataTable Dt = new DataTable(); Dt = BRANCH_RECMASLogicLayer.GetAllBRANCH_REC_MASDetails(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(); } GvBranchReceivedMaster.DataSource = Dv.ToTable(); GvBranchReceivedMaster.DataBind(); DtSearch = Dv.ToTable(); }
protected void btnSave_Click(object sender, EventArgs e) { try { #region UPADTE BRANCH RECEIVED MASTER BRANCH_RECMASLogicLayer insert = new BRANCH_RECMASLogicLayer(); //insert.COMP_CODE = HfCompCode.Value.Trim(); //insert.BRANCH_CODE = HfBranchCode.Value.Trim(); insert.TRAN_DATE = Convert.ToDateTime(HfTranDate.Value.Trim()).ToString("MM-dd-yyyy"); insert.TRAN_NO = HfTranNo.Value.Trim(); //insert.TRAN_TYPE = HfTranType.Value.Trim().ToUpper(); //insert.TO_BRANCH_CODE = HfToBranchCode.Value.Trim(); //insert.CHA_NO = TxtChallanNo.Text.Trim(); //insert.CHA_DT = Convert.ToDateTime(TxtChallanDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy"); //insert.SERIALNO = TxtSrNo.Text.Trim(); //insert.VEHICLE_NO = TxtVehclieNo.Text.Trim().ToUpper(); //insert.TCODE = null; //insert.TRANSPORT = TxtTransportName.Text.Trim().ToUpper(); //insert.LR_NO = TxtLRNumber.Text.Trim(); //insert.LR_DATE = Convert.ToDateTime(TxtChallanDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy"); //insert.DRIVER_NAME = TxtDriverName.Text.Trim().ToUpper(); //insert.DRIVER_ADD = TxtDriverAddress.Text.Trim().ToUpper(); //insert.MDLNO = TxtMDLNo.Text.Trim().ToUpper(); //insert.MDLSTATE = TxtMDLState.Text.Trim().ToUpper(); //insert.REMARK = TxtRemark.Text.Trim().ToUpper(); //insert.FORM_SRNO = null; //insert.CHECKPOST_NAME = ""; //insert.TOT_QTY = null; //insert.TOT_AMT = null; //insert.ENDT = ""; //insert.STATUS = ""; //insert.INS_USERID = Session["USERNAME"].ToString(); //insert.INS_DATE = ""; //insert.UPD_USERID = Session["USERNAME"].ToString(); //insert.UPD_DATE = ""; //insert.REF_TRAN_DATE = ""; //insert.REF_TRAN_NO = null; //insert.ISS_FLAG = ""; insert.REC_FLAG = DdlReceivedFlag.SelectedValue.Trim().ToUpper(); if (DdlReceivedFlag.SelectedValue == "Y") { insert.REC_USERID = TxtReceivedBy.Text.Trim().ToUpper(); } else { insert.REC_USERID = ""; } if (DdlReceivedFlag.SelectedValue == "Y") { insert.REC_DATE = Convert.ToDateTime(TxtReceivedDate.Text.Trim().ToUpper()).ToString("MM-dd-yyyy"); } else { insert.REC_DATE = ""; } //insert.GST_APP_FLAG = ""; //insert.PARTY_TYPE = ""; //insert.INV_NO = ""; //insert.INV_DT = ""; //insert.EWAY_BILLNO = ""; //insert.GST_RATE = null; //insert.GST_AMT = null; //insert.CGST_RATE = null; //insert.CGST_AMT = null; //insert.SGST_RATE = null; //insert.SGST_AMT = null; //insert.IGST_RATE = null; //insert.IGST_AMT = null; //insert.RO_AMT = null; //insert.NET_AMT = null; //insert.FROM_BRANCH_ACODE = null; #endregion #region BRANCH RECEIVED STOCK DETAILS //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 SRNODETAIL = 1; //foreach (GridViewRow row in GvBranchReceivedDetails.Rows) //{ // if (row.RowType == DataControlRowType.DataRow) // { // HiddenField HfDetailSCode = row.FindControl("HfDetailSCode") as HiddenField; // HiddenField HfRefTranDate = row.FindControl("HfRefTranDate") as HiddenField; // HiddenField HfRefTranNo = row.FindControl("HfRefTranNo") as HiddenField; // HiddenField HfRefSrNo = row.FindControl("HfRefSrNo") as HiddenField; // TextBox TxtProductName = row.FindControl("TxtProductName") as TextBox; // TextBox TxtQty = row.FindControl("TxtQty") as TextBox; // TextBox TxtRate = row.FindControl("TxtRate") as TextBox; // TextBox TxtAmount = row.FindControl("TxtAmount") as TextBox; // if (HfDetailSCode.Value != "0" && HfDetailSCode.Value != null) // { // XmlElement HandleDetail2 = XDoc1.CreateElement("STK_IRDETDetails"); // HandleDetail2.SetAttribute("SRNO", SRNODETAIL.ToString()); // HandleDetail2.SetAttribute("COMP_CODE", Session["COMP_CODE"].ToString()); // HandleDetail2.SetAttribute("TRAN_NO", HfTranNo.Value.Trim()); // HandleDetail2.SetAttribute("TRAN_DATE", HfTranDate.Value.Trim()); // if (HfDetailSCode.Value == string.Empty) // { // HandleDetail2.SetAttribute("SCODE", ("0")); // } // else // { // HandleDetail2.SetAttribute("SCODE", (HfDetailSCode.Value)); // } // if (HfRefTranDate.Value == string.Empty) // { // HandleDetail2.SetAttribute("REF_TRAN_DATE", ("")); // } // else // { // HandleDetail2.SetAttribute("REF_TRAN_DATE", (Convert.ToDateTime(HfRefTranDate.Value).ToString("MM-dd-yyyy"))); // } // if (HfRefTranNo.Value == string.Empty) // { // HandleDetail2.SetAttribute("REF_TRAN_NO", ("0")); // } // else // { // HandleDetail2.SetAttribute("REF_TRAN_NO", (HfRefTranNo.Value.Trim())); // } // if (HfRefSrNo.Value == string.Empty) // { // HandleDetail2.SetAttribute("REF_SRNO", ("0")); // } // else // { // HandleDetail2.SetAttribute("REF_SRNO", (SRNODETAIL.ToString())); // } // if (TxtQty.Text == string.Empty) // { // HandleDetail2.SetAttribute("QTY", ("0")); // } // else // { // HandleDetail2.SetAttribute("QTY", (TxtQty.Text.Trim())); // } // if (TxtRate.Text == string.Empty) // { // HandleDetail2.SetAttribute("RATE", ("0")); // } // else // { // HandleDetail2.SetAttribute("RATE", (TxtRate.Text.Trim())); // } // if (TxtAmount.Text == string.Empty) // { // HandleDetail2.SetAttribute("AMT", ("0")); // } // else // { // HandleDetail2.SetAttribute("AMT", (TxtAmount.Text.Trim())); // } // root1.AppendChild(HandleDetail2); // SRNODETAIL++; // } // } #endregion // } string str = BRANCH_RECMASLogicLayer.UpdateBRANCH_REC_MASDetail(insert); if (str.Contains("successfully")) { lblmsg.Text = "BRANCH RECEIVED MASTER SAVE SUCCESSFULLY."; lblmsg.ForeColor = Color.Green; clear(); FillBRANCH_RECMAS_MasterGrid(Session["COMP_CODE"].ToString()); UserRights(); } else if (str.Contains("Already") || str.Contains("PRIMARY KEY")) { lblmsg.Text = "BRANCH RECEIVED MASTER ALREADY EXIST."; lblmsg.ForeColor = Color.Red; } else { lblmsg.Text = "ERROR :BRANCH RECEIVED MASTER NOT SAVED"; lblmsg.ForeColor = Color.Red; } } catch (Exception) { throw; } }
protected void GvBranchReceivedMaster_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Deletea") { #region DELETE // clear(); int id = int.Parse(e.CommandArgument.ToString()); Control ctrl = e.CommandSource as Control; if (ctrl != null) { GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow; HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; DataSet ds = BRANCH_RECMASLogicLayer.GetAllIDWiseBRANCH_REC_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); DataTable dt = ds.Tables[0]; DataTable DtDetails = ds.Tables[1]; DataTable DtBarcode = ds.Tables[2]; DataTable DtNewBarcode = ds.Tables[3]; if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfBranchCode.Value = dt.Rows[0]["BRANCH_CODE"].ToString(); FillToBranchOnUpdate(dt.Rows[0]["TO_BRANCH_CODE"].ToString()); HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); HfRef_TranDate.Value = dt.Rows[0]["REF_TRAN_DATE"].ToString(); HfRef_TranNo.Value = dt.Rows[0]["REF_TRAN_NO"].ToString(); HfTranType.Value = dt.Rows[0]["TRAN_TYPE"].ToString(); TxtChallanNo.Text = dt.Rows[0]["CHA_NO"].ToString(); TxtChallanDate.Text = Convert.ToDateTime(dt.Rows[0]["CHA_DT"].ToString()).ToString("dd-MM-yyyy"); TxtSrNo.Text = dt.Rows[0]["SERIALNO"].ToString(); TxtTransportName.Text = dt.Rows[0]["TRANSPORT"].ToString(); TxtVehclieNo.Text = dt.Rows[0]["VEHICLE_NO"].ToString(); TxtDriverName.Text = dt.Rows[0]["DRIVER_NAME"].ToString(); TxtDriverAddress.Text = dt.Rows[0]["DRIVER_ADD"].ToString(); TxtMDLNo.Text = dt.Rows[0]["MDLNO"].ToString(); TxtMDLState.Text = dt.Rows[0]["MDLSTATE"].ToString(); TxtLRDate.Text = dt.Rows[0]["LR_DATE"].ToString();//Convert.ToDateTime(dt.Rows[0]["LR_DATE"].ToString()).ToString("dd-MM-yyyy"); TxtLRNumber.Text = dt.Rows[0]["LR_NO"].ToString(); DdlReceivedFlag.SelectedValue = dt.Rows[0]["REC_FLAG"].ToString(); TxtReceivedDate.Text = dt.Rows[0]["REC_DATE"].ToString(); TxtReceivedBy.Text = dt.Rows[0]["REC_USERID"].ToString(); if (DtDetails.Rows.Count > 0) { GvBranchReceivedDetails.DataSource = DtDetails; GvBranchReceivedDetails.DataBind(); GvBranchReceivedDetails.Enabled = false; } if (DdlReceivedFlag.SelectedValue == "N") { if (DtBarcode.Rows.Count > 0) { GvBranchReceivedBarcodeGrid.DataSource = DtBarcode; GvBranchReceivedBarcodeGrid.DataBind(); GvBranchReceivedBarcodeGrid.Enabled = false; } } else if (DdlReceivedFlag.SelectedValue == "Y") { GvBranchReceivedBarcodeGrid.DataSource = DtNewBarcode; GvBranchReceivedBarcodeGrid.DataBind(); GvBranchReceivedBarcodeGrid.Enabled = false; } btnSave.Visible = false; btnDelete.Visible = true; Btncalldel.Visible = true; BtncallUpd.Visible = false; ControllerDisable(); } } } #endregion if (e.CommandName == "Edita") { #region EDIT // clear(); int id = int.Parse(e.CommandArgument.ToString()); Control ctrl = e.CommandSource as Control; if (ctrl != null) { GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow; HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; DataSet ds = BRANCH_RECMASLogicLayer.GetAllIDWiseBRANCH_REC_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); DataTable dt = ds.Tables[0]; DataTable DtDetails = ds.Tables[1]; DataTable DtBarcode = ds.Tables[2]; DataTable DtNewBarcode = ds.Tables[3]; if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfBranchCode.Value = dt.Rows[0]["BRANCH_CODE"].ToString(); FillToBranchOnUpdate(dt.Rows[0]["TO_BRANCH_CODE"].ToString()); HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); HfRef_TranDate.Value = dt.Rows[0]["REF_TRAN_DATE"].ToString(); HfRef_TranNo.Value = dt.Rows[0]["REF_TRAN_NO"].ToString(); HfTranType.Value = dt.Rows[0]["TRAN_TYPE"].ToString(); TxtChallanNo.Text = dt.Rows[0]["CHA_NO"].ToString(); TxtChallanDate.Text = Convert.ToDateTime(dt.Rows[0]["CHA_DT"].ToString()).ToString("dd-MM-yyyy"); TxtSrNo.Text = dt.Rows[0]["SERIALNO"].ToString(); TxtTransportName.Text = dt.Rows[0]["TRANSPORT"].ToString(); TxtVehclieNo.Text = dt.Rows[0]["VEHICLE_NO"].ToString(); TxtDriverName.Text = dt.Rows[0]["DRIVER_NAME"].ToString(); TxtDriverAddress.Text = dt.Rows[0]["DRIVER_ADD"].ToString(); TxtMDLNo.Text = dt.Rows[0]["MDLNO"].ToString(); TxtMDLState.Text = dt.Rows[0]["MDLSTATE"].ToString(); TxtLRDate.Text = dt.Rows[0]["LR_DATE"].ToString();//Convert.ToDateTime(dt.Rows[0]["LR_DATE"].ToString()).ToString("dd-MM-yyyy"); TxtLRNumber.Text = dt.Rows[0]["LR_NO"].ToString(); DdlReceivedFlag.SelectedValue = dt.Rows[0]["REC_FLAG"].ToString(); TxtReceivedDate.Text = dt.Rows[0]["REC_DATE"].ToString(); TxtReceivedBy.Text = dt.Rows[0]["REC_USERID"].ToString(); if (DtDetails.Rows.Count > 0) { GvBranchReceivedDetails.DataSource = DtDetails; GvBranchReceivedDetails.DataBind(); GvBranchReceivedDetails.Enabled = false; } if (DdlReceivedFlag.SelectedValue == "N") { if (DtBarcode.Rows.Count > 0) { GvBranchReceivedBarcodeGrid.DataSource = DtBarcode; GvBranchReceivedBarcodeGrid.DataBind(); GvBranchReceivedBarcodeGrid.Enabled = false; } } else if (DdlReceivedFlag.SelectedValue == "Y") { GvBranchReceivedBarcodeGrid.DataSource = DtNewBarcode; GvBranchReceivedBarcodeGrid.DataBind(); GvBranchReceivedBarcodeGrid.Enabled = false; } 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; UserRights(); } if (e.CommandName == "Viewa") { #region SET TEXT ON VIEW // clear(); int id = int.Parse(e.CommandArgument.ToString()); Control ctrl = e.CommandSource as Control; if (ctrl != null) { GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow; HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; DataSet ds = BRANCH_RECMASLogicLayer.GetAllIDWiseBRANCH_REC_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); DataTable dt = ds.Tables[0]; DataTable DtDetails = ds.Tables[1]; DataTable DtBarcode = ds.Tables[2]; DataTable DtNewBarcode = ds.Tables[3]; if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfBranchCode.Value = dt.Rows[0]["BRANCH_CODE"].ToString(); FillToBranchOnUpdate(dt.Rows[0]["TO_BRANCH_CODE"].ToString()); HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); HfRef_TranDate.Value = dt.Rows[0]["REF_TRAN_DATE"].ToString(); HfRef_TranNo.Value = dt.Rows[0]["REF_TRAN_NO"].ToString(); HfTranType.Value = dt.Rows[0]["TRAN_TYPE"].ToString(); TxtChallanNo.Text = dt.Rows[0]["CHA_NO"].ToString(); TxtChallanDate.Text = Convert.ToDateTime(dt.Rows[0]["CHA_DT"].ToString()).ToString("dd-MM-yyyy"); TxtSrNo.Text = dt.Rows[0]["SERIALNO"].ToString(); TxtTransportName.Text = dt.Rows[0]["TRANSPORT"].ToString(); TxtVehclieNo.Text = dt.Rows[0]["VEHICLE_NO"].ToString(); TxtDriverName.Text = dt.Rows[0]["DRIVER_NAME"].ToString(); TxtDriverAddress.Text = dt.Rows[0]["DRIVER_ADD"].ToString(); TxtMDLNo.Text = dt.Rows[0]["MDLNO"].ToString(); TxtMDLState.Text = dt.Rows[0]["MDLSTATE"].ToString(); TxtLRDate.Text = dt.Rows[0]["LR_DATE"].ToString();//Convert.ToDateTime(dt.Rows[0]["LR_DATE"].ToString()).ToString("dd-MM-yyyy"); TxtLRNumber.Text = dt.Rows[0]["LR_NO"].ToString(); DdlReceivedFlag.SelectedValue = dt.Rows[0]["REC_FLAG"].ToString(); TxtReceivedDate.Text = dt.Rows[0]["REC_DATE"].ToString(); TxtReceivedBy.Text = dt.Rows[0]["REC_USERID"].ToString(); if (DtDetails.Rows.Count > 0) { GvBranchReceivedDetails.DataSource = DtDetails; GvBranchReceivedDetails.DataBind(); GvBranchReceivedDetails.Enabled = false; } if (DdlReceivedFlag.SelectedValue == "N") { if (DtBarcode.Rows.Count > 0) { GvBranchReceivedBarcodeGrid.DataSource = DtBarcode; GvBranchReceivedBarcodeGrid.DataBind(); GvBranchReceivedBarcodeGrid.Enabled = false; } } else if (DdlReceivedFlag.SelectedValue == "Y") { GvBranchReceivedBarcodeGrid.DataSource = DtNewBarcode; GvBranchReceivedBarcodeGrid.DataBind(); GvBranchReceivedBarcodeGrid.Enabled = false; } } } #endregion ControllerDisable(); btnSave.Visible = false; Btncalldel.Visible = false; BtncallUpd.Visible = false; UserRights(); } } catch (Exception) { throw; } }