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