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