private void SetInitialRowBarcodeGrid()
{
DataTable table = new DataTable();
DataRow dr = null;
table.Columns.Add("COMP_CODE", typeof(string));
table.Columns.Add("TRAN_DATE", typeof(string));
table.Columns.Add("TRAN_NO", typeof(string));
table.Columns.Add("SRNO", typeof(string));
//table.Columns.Add("BAR_TRAN_DATE", typeof(string));
//table.Columns.Add("BAR_TRAN_NO", typeof(string));
//table.Columns.Add("BAR_SRNO", typeof(string));
table.Columns.Add("SCODE", typeof(string));
//table.Columns.Add("QTY", typeof(string));
table.Columns.Add("RATE", typeof(string));
//table.Columns.Add("AMT", typeof(string));
table.Columns.Add("BARCODE", typeof(string));
table.Columns.Add("STATUS", typeof(string));
dr = table.NewRow();
dr["COMP_CODE"] = string.Empty;
dr["TRAN_DATE"] = string.Empty;
dr["TRAN_NO"] = string.Empty;
dr["SRNO"] = string.Empty;
//dr["BAR_TRAN_DATE"] = string.Empty;
//dr["BAR_TRAN_NO"] = string.Empty;
//dr["BAR_SRNO"] = string.Empty;
dr["SCODE"] = string.Empty;
//dr["QTY"] = string.Empty;
dr["RATE"] = string.Empty;
//dr["AMT"] = string.Empty;
dr["BARCODE"] = string.Empty;
dr["STATUS"] = string.Empty;
table.Rows.Add(dr);
ViewState["CurrentTable_Barcode"] = table;
GvBranchReceivedBarcodeGrid.DataSource = table;
GvBranchReceivedBarcodeGrid.DataBind();
}
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;
}
}
