protected void btnUploadBarcodeProcess_Click(object sender, EventArgs e) { try { if (FileUpload1.HasFile == true) { string FileName = Path.GetFileName(FileUpload1.PostedFile.FileName); string Extension = Path.GetExtension(FileUpload1.PostedFile.FileName); string FolderPath = ConfigurationManager.AppSettings["FolderPath"]; string FilePath = Server.MapPath(FolderPath + FileName); FileUpload1.SaveAs(FilePath); DataTable DtCust = ImportExceltoDatatable(FilePath); DataTable DtBarcodeTemp = new DataTable(); DtBarcodeTemp.Columns.Add("BARRCODE", typeof(string)); DtBarcodeTemp.Columns.Add("QTY", typeof(string)); DtBarcodeTemp.Columns.Add("SCODE", typeof(string)); DtBarcodeTemp.Columns.Add("BAR_TRAN_DATE", typeof(string)); DtBarcodeTemp.Columns.Add("BAR_TRAN_NO", typeof(string)); DtBarcodeTemp.Columns.Add("BAR_SRNO", typeof(string)); DataRow dr = null; for (int i = 0; i < DtCust.Rows.Count; i++) { dr = DtBarcodeTemp.NewRow(); dr["BARRCODE"] = DtCust.Rows[i]["BARRCODE"].ToString(); dr["QTY"] = "1"; dr["SCODE"] = string.Empty; dr["BAR_TRAN_DATE"] = string.Empty; dr["BAR_TRAN_NO"] = string.Empty; dr["BAR_SRNO"] = string.Empty; DtBarcodeTemp.Rows.Add(dr); } GvViewBarcode.DataSource = DtBarcodeTemp; GvViewBarcode.DataBind(); ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ShowModelViewBarcode", "ShowModelViewBarcode()", true); } } catch (Exception) { throw; } }
public void FillViewBarcodePopup(int C) { try { DataTable dt = new DataTable(); dt.Columns.Add("BARRCODE", typeof(System.String)); dt.Columns.Add("QTY", typeof(System.String)); dt.Columns.Add("SCODE", typeof(System.String)); dt.Columns.Add("BAR_TRAN_DATE", typeof(System.String)); dt.Columns.Add("BAR_TRAN_NO", typeof(System.String)); dt.Columns.Add("BAR_SRNO", typeof(System.String)); for (int i = 0; i < 50; i++) { DataRow dr = dt.NewRow(); dr["BARRCODE"] = ""; dr["QTY"] = ""; dr["SCODE"] = ""; dr["BAR_TRAN_DATE"] = ""; dr["BAR_TRAN_NO"] = ""; dr["BAR_SRNO"] = ""; dt.Rows.Add(dr); } if (C == 1) { //ViewState["BarcodeTemp"] = dt; } GvViewBarcode.DataSource = dt; GvViewBarcode.DataBind(); } catch (Exception) { throw; } }
protected void AddNewRowBarcodeView() { try { //if (ViewState["BarcodeTemp"] != null) //{ // DataTable dtCurrentTable = (DataTable)ViewState["BarcodeTemp"]; // DataRow dr = null; // if (dtCurrentTable.Rows.Count > 0) // { // dr = dtCurrentTable.NewRow(); // dr["BARRCODE"] = ""; // dr["QTY"] = ""; // dr["SCODE"] = ""; // dr["BAR_TRAN_DATE"] = ""; // dr["BAR_TRAN_NO"] = ""; // dr["BAR_SRNO"] = ""; // dtCurrentTable.Rows.Add(dr); // ViewState["BarcodeTemp"] = dtCurrentTable; // GvViewBarcode.DataSource = dtCurrentTable; // GvViewBarcode.DataBind(); // } //} //else //{ DataTable dtCurrentTableBlankFilter = new DataTable(); DataTable dtCurrentTable = new DataTable(); DataRow dr = null; if (ViewState["BarcodeTempNew"] != null) { dtCurrentTableBlankFilter = (DataTable)ViewState["BarcodeTempNew"]; DataView dvBlankFilter = new DataView(dtCurrentTableBlankFilter); dvBlankFilter.RowFilter = "BARRCODE<>''"; dtCurrentTable = dvBlankFilter.ToTable(); //dtCurrentTable = (DataTable)ViewState["BarcodeTempNew"]; //NEW BLOCK FOR ADD SECOND ROW ISSUE ON 13-09-2019 foreach (GridViewRow row in GvViewBarcode.Rows) { if (row.RowType == DataControlRowType.DataRow) { TextBox TxtBarcode = row.FindControl("TxtBarcode") as TextBox; TextBox TxtQty = row.FindControl("TxtQty") as TextBox; HiddenField HfBarTranNo = row.FindControl("HfBarTranNo") as HiddenField; HiddenField HfBarTranDate = row.FindControl("HfBarTranDate") as HiddenField; HiddenField HfBarSrNo = row.FindControl("HfBarSrNo") as HiddenField; if (TxtBarcode.Text.Trim() != string.Empty) { DataView dv = new DataView(dtCurrentTable); dv.RowFilter = "BARRCODE='" + TxtBarcode.Text.Trim() + "'"; DataTable dtCurrentTableFilter = new DataTable(); dtCurrentTableFilter = dv.ToTable(); if (dtCurrentTableFilter.Rows.Count <= 0) { dr = dtCurrentTable.NewRow(); //dr = dtCurrentTable.Rows[dtCurrentTable.Rows.Count - 1]; dr["BARRCODE"] = TxtBarcode.Text.Trim(); dr["QTY"] = TxtQty.Text.Trim(); dr["SCODE"] = ""; dr["BAR_TRAN_DATE"] = HfBarTranDate.Value; dr["BAR_TRAN_NO"] = HfBarTranNo.Value; dr["BAR_SRNO"] = HfBarSrNo.Value; dtCurrentTable.Rows.Add(dr); } } } } //*****// } else { dtCurrentTable.Columns.Add("BARRCODE", typeof(System.String)); dtCurrentTable.Columns.Add("QTY", typeof(System.String)); dtCurrentTable.Columns.Add("SCODE", typeof(System.String)); dtCurrentTable.Columns.Add("BAR_TRAN_DATE", typeof(System.String)); dtCurrentTable.Columns.Add("BAR_TRAN_NO", typeof(System.String)); dtCurrentTable.Columns.Add("BAR_SRNO", typeof(System.String)); foreach (GridViewRow row in GvViewBarcode.Rows) { if (row.RowType == DataControlRowType.DataRow) { TextBox TxtBarcode = row.FindControl("TxtBarcode") as TextBox; TextBox TxtQty = row.FindControl("TxtQty") as TextBox; HiddenField HfBarTranNo = row.FindControl("HfBarTranNo") as HiddenField; HiddenField HfBarTranDate = row.FindControl("HfBarTranDate") as HiddenField; HiddenField HfBarSrNo = row.FindControl("HfBarSrNo") as HiddenField; if (TxtBarcode.Text.Trim() != string.Empty) { dr = dtCurrentTable.NewRow(); dr["BARRCODE"] = TxtBarcode.Text.Trim(); dr["QTY"] = TxtQty.Text.Trim(); dr["SCODE"] = ""; dr["BAR_TRAN_DATE"] = HfBarTranDate.Value; dr["BAR_TRAN_NO"] = HfBarTranNo.Value; dr["BAR_SRNO"] = HfBarSrNo.Value; dtCurrentTable.Rows.Add(dr); } } } } dr = dtCurrentTable.NewRow(); dr["BARRCODE"] = ""; dr["QTY"] = ""; dr["SCODE"] = ""; dr["BAR_TRAN_DATE"] = ""; dr["BAR_TRAN_NO"] = ""; dr["BAR_SRNO"] = ""; dtCurrentTable.Rows.Add(dr); ViewState["BarcodeTempNew"] = dtCurrentTable; GvViewBarcode.DataSource = dtCurrentTable; GvViewBarcode.DataBind(); //} } catch (Exception) { throw; } }
protected void TxtBarcodeInputNo_TextChanged(object sender, EventArgs e) { try { if (TxtBarcodeInputNo.Text.Trim() != string.Empty && validation.isNumberWithoutComa(TxtBarcodeInputNo.Text.Trim())) { DataTable dtCurrentTableBlankFilter = new DataTable(); DataTable dtCurrentTable = new DataTable(); DataRow dr = null; if (ViewState["BarcodeTempNew"] != null) { dtCurrentTableBlankFilter = (DataTable)ViewState["BarcodeTempNew"]; DataView dvBlankFilter = new DataView(dtCurrentTableBlankFilter); dvBlankFilter.RowFilter = "BARRCODE<>''"; dtCurrentTable = dvBlankFilter.ToTable(); //NEW BLOCK FOR ADD SECOND ROW ISSUE ON 13-09-2019 foreach (GridViewRow row in GvViewBarcode.Rows) { if (row.RowType == DataControlRowType.DataRow) { TextBox TxtBarcode = row.FindControl("TxtBarcode") as TextBox; TextBox TxtQty = row.FindControl("TxtQty") as TextBox; HiddenField HfBarTranNo = row.FindControl("HfBarTranNo") as HiddenField; HiddenField HfBarTranDate = row.FindControl("HfBarTranDate") as HiddenField; HiddenField HfBarSrNo = row.FindControl("HfBarSrNo") as HiddenField; if (TxtBarcode.Text.Trim() != string.Empty) { DataView dv = new DataView(dtCurrentTable); dv.RowFilter = "BARRCODE='" + TxtBarcode.Text.Trim() + "'"; DataTable dtCurrentTableFilter = new DataTable(); dtCurrentTableFilter = dv.ToTable(); if (dtCurrentTableFilter.Rows.Count <= 0) { dr = dtCurrentTable.NewRow(); //dr = dtCurrentTable.Rows[dtCurrentTable.Rows.Count - 1]; dr["BARRCODE"] = TxtBarcode.Text.Trim(); dr["QTY"] = TxtQty.Text.Trim(); dr["SCODE"] = ""; dr["BAR_TRAN_DATE"] = HfBarTranDate.Value; dr["BAR_TRAN_NO"] = HfBarTranNo.Value; dr["BAR_SRNO"] = HfBarSrNo.Value; dtCurrentTable.Rows.Add(dr); } } } } //*****// } else { dtCurrentTable.Columns.Add("BARRCODE", typeof(System.String)); dtCurrentTable.Columns.Add("QTY", typeof(System.String)); dtCurrentTable.Columns.Add("SCODE", typeof(System.String)); dtCurrentTable.Columns.Add("BAR_TRAN_DATE", typeof(System.String)); dtCurrentTable.Columns.Add("BAR_TRAN_NO", typeof(System.String)); dtCurrentTable.Columns.Add("BAR_SRNO", typeof(System.String)); foreach (GridViewRow row in GvViewBarcode.Rows) { if (row.RowType == DataControlRowType.DataRow) { TextBox TxtBarcode = row.FindControl("TxtBarcode") as TextBox; TextBox TxtQty = row.FindControl("TxtQty") as TextBox; HiddenField HfBarTranNo = row.FindControl("HfBarTranNo") as HiddenField; HiddenField HfBarTranDate = row.FindControl("HfBarTranDate") as HiddenField; HiddenField HfBarSrNo = row.FindControl("HfBarSrNo") as HiddenField; if (TxtBarcode.Text.Trim() != string.Empty) { dr = dtCurrentTable.NewRow(); dr["BARRCODE"] = TxtBarcode.Text.Trim(); dr["QTY"] = TxtQty.Text.Trim(); dr["SCODE"] = ""; dr["BAR_TRAN_DATE"] = HfBarTranDate.Value; dr["BAR_TRAN_NO"] = HfBarTranNo.Value; dr["BAR_SRNO"] = HfBarSrNo.Value; dtCurrentTable.Rows.Add(dr); } } } } for (int j = 0; j < Convert.ToInt32(TxtBarcodeInputNo.Text.Trim()); j++) { dr = dtCurrentTable.NewRow(); dr["BARRCODE"] = ""; dr["QTY"] = ""; dr["SCODE"] = ""; dr["BAR_TRAN_DATE"] = ""; dr["BAR_TRAN_NO"] = ""; dr["BAR_SRNO"] = ""; dtCurrentTable.Rows.Add(dr); } ViewState["BarcodeTempNew"] = dtCurrentTable; GvViewBarcode.DataSource = dtCurrentTable; GvViewBarcode.DataBind(); TxtBarcodeInputNo.Text = string.Empty; } else { //alert ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('invalid number')", true); } } catch (Exception) { throw; } }