private void Populate(Int64 MtrlRcptHeadId)
{
try
{
ChallanDelverdDAL objChallanDelverdDAL = new ChallanDelverdDAL();
tblChlnDelvHead objtblChlnDelvHead = objChallanDelverdDAL.SelectHeadInEdit(MtrlRcptHeadId);
if (objtblChlnDelvHead != null)
{
txtDate.Text = Convert.ToDateTime(objtblChlnDelvHead.ChlnDelv_Date).Date.ToString("dd-MM-yyyy");
ddlDateRange.SelectedValue = Convert.ToString(objtblChlnDelvHead.Year_Idno);
ddlToCity.SelectedValue = Convert.ToString(objtblChlnDelvHead.ToCity_Idno);
ddlToCity_SelectedIndexChanged(null, null);
txtRcptNo.Text = objtblChlnDelvHead.ChlnDelv_No.ToString();
ddlChallanDetl.SelectedValue = objtblChlnDelvHead.ChlnTransf_Idno.ToString();
hidMtrlRcptid.Value = objtblChlnDelvHead.ChlnDelvHead_Idno.ToString();
txtLocGrAmnt.Text = Convert.ToDouble(objtblChlnDelvHead.LocGR_Amnt).ToString("N2");
txtoutGrAmnt.Text = Convert.ToDouble(objtblChlnDelvHead.CrsngGR_Amnt).ToString("N2");
txtNetAmnt.Text = Convert.ToDouble(objtblChlnDelvHead.Net_Amnt).ToString("N2");
lblRcptDtNo.Text = "Receipt Date";
}
DataSet Ds = objChallanDelverdDAL.SelectGridDetlInEdit(ApplicationFunction.ConnectionString(), MtrlRcptHeadId);
objChallanDelverdDAL = null;
ViewState["dt"] = (DataTable)Ds.Tables[0];
grdMain.DataSource = ViewState["dt"];
grdMain.DataBind();
}
catch (Exception e) { }
}
public int DeleteALL(Int64 HeadIdno)
{
int Value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
List <tblChlnDelvDetl> objTranDetl = (from objDetl in db.tblChlnDelvDetls
where objDetl.ChlnDelvHead_Idno == HeadIdno
select objDetl).ToList();
if (objTranDetl != null)
{
foreach (var d in objTranDetl)
{
db.tblChlnDelvDetls.DeleteObject(d);
db.SaveChanges();
}
List <TblGrHead> objTblGrHead = (from objDetl in db.TblGrHeads
where objDetl.ChlnDelv_Idno == HeadIdno
select objDetl).ToList();
if (objTblGrHead != null)
{
foreach (var lst in objTblGrHead)
{
lst.ChlnDelv_Idno = 0;
lst.Gr_Delv = false;
db.SaveChanges();
}
}
tblChlnDelvHead objTransHead = (from objHead in db.tblChlnDelvHeads
where objHead.ChlnDelvHead_Idno == HeadIdno
select objHead).SingleOrDefault();
if (objTransHead != null)
{
db.tblChlnDelvHeads.DeleteObject(objTransHead);
db.SaveChanges();
Value = 1;
tScope.Complete();
}
}
}
}
}
catch (Exception Ex)
{
}
return(Value);
}
public tblChlnDelvHead IsExists(Int64 MtrlTransfIdno, int FromCityIdno, Int64 MtrlRcptIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblChlnDelvHead objMtrlRcptHOHead = new tblChlnDelvHead();
if (MtrlRcptIdno <= 0)
{
objMtrlRcptHOHead = (from obj in db.tblChlnDelvHeads
where obj.ChlnTransf_Idno == MtrlTransfIdno &&
obj.ToCity_Idno == FromCityIdno
select obj).SingleOrDefault();
}
else if (MtrlRcptIdno > 0)
{
objMtrlRcptHOHead = (from obj in db.tblChlnDelvHeads
where obj.ChlnTransf_Idno == MtrlTransfIdno &&
obj.ToCity_Idno == FromCityIdno &&
obj.ChlnDelvHead_Idno != MtrlRcptIdno
select obj).SingleOrDefault();
}
return(objMtrlRcptHOHead);
}
}
public int DeleteMtrlRcptHO(Int64 RcptIdno)
{
int Value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
List <tblChlnDelvDetl> objRcptDetl = (from objDetl in db.tblChlnDelvDetls
where objDetl.Id == RcptIdno
select objDetl).ToList();
if (objRcptDetl != null)
{
db.DeleteObject(objRcptDetl);
db.SaveChanges();
tblChlnDelvHead objRcptHead = (from objHead in db.tblChlnDelvHeads
where objHead.ChlnDelvHead_Idno == RcptIdno
select objHead).SingleOrDefault();
if (objRcptHead != null)
{
db.DeleteObject(objRcptHead);
db.SaveChanges();
Value = 1;
tScope.Complete();
}
}
}
}
}
catch (Exception Ex)
{
}
return(Value);
}
public Int64 UpdateMtrlRcptHOHead(tblChlnDelvHead objMtrlRcptHOHead, DataTable DtTemp, Int32 HeadIdno)
{
Int64 RcptHeadIdno = HeadIdno;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblChlnDelvHead RH = db.tblChlnDelvHeads.Where(rh => (rh.ChlnTransf_Idno == objMtrlRcptHOHead.ChlnTransf_Idno) && (rh.ToCity_Idno == objMtrlRcptHOHead.ToCity_Idno) && (rh.Year_Idno == objMtrlRcptHOHead.Year_Idno) && (rh.ChlnDelvHead_Idno != HeadIdno)).FirstOrDefault();
if (RH != null)
{
RcptHeadIdno = -1;
}
else
{
tblChlnDelvHead objRcptHOHead = (from obj in db.tblChlnDelvHeads
where obj.ChlnDelvHead_Idno == RcptHeadIdno
select obj).SingleOrDefault();
if (objRcptHOHead != null)
{
objRcptHOHead.ChlnDelv_Date = objMtrlRcptHOHead.ChlnDelv_Date;
objRcptHOHead.ToCity_Idno = objMtrlRcptHOHead.ToCity_Idno;
objRcptHOHead.ChlnTransf_Idno = objMtrlRcptHOHead.ChlnTransf_Idno;
objRcptHOHead.LocGR_Amnt = objMtrlRcptHOHead.LocGR_Amnt;
objRcptHOHead.CrsngGR_Amnt = objMtrlRcptHOHead.CrsngGR_Amnt;
objRcptHOHead.Net_Amnt = objMtrlRcptHOHead.Net_Amnt;
objRcptHOHead.Date_Modified = MultipleDBDAL.GetIndianDateTime().Date; // DateTime.Now.Date;
objRcptHOHead.Year_Idno = objMtrlRcptHOHead.Year_Idno;
db.SaveChanges();
}
List <tblChlnDelvDetl> ChlnDetl = db.tblChlnDelvDetls.Where(rd => rd.ChlnDelvHead_Idno == RcptHeadIdno).ToList();
foreach (tblChlnDelvDetl rgd in ChlnDetl)
{
db.tblChlnDelvDetls.DeleteObject(rgd);
db.SaveChanges();
}
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
tblChlnDelvDetl objtblChlnDelvDetl = new tblChlnDelvDetl();
objtblChlnDelvDetl.Gr_Idno = Convert.ToInt32(Dr["Gr_Idno"]);
objtblChlnDelvDetl.Item_Idno = Convert.ToInt32(Dr["Item_Idno"]);
objtblChlnDelvDetl.Unit_Idno = Convert.ToInt32(Dr["Unit_Idno"]);
objtblChlnDelvDetl.Rate_Type = Convert.ToInt32(Dr["Rate_Type"]);
objtblChlnDelvDetl.Qty = Convert.ToInt32(Dr["Qty"]);
objtblChlnDelvDetl.Weight = Convert.ToDouble(Dr["Weight"]);
objtblChlnDelvDetl.Amount = Convert.ToDouble(Dr["Amount"]);
objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]);
objtblChlnDelvDetl.Delv_Qty = Convert.ToDouble(Dr["Delv_Qty"]);
objtblChlnDelvDetl.Delv_Weight = Convert.ToDouble(Dr["Delv_Wt"]);
objtblChlnDelvDetl.Delv_Amount = Convert.ToDouble(Dr["Delv_Amount"]);
objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]);
objtblChlnDelvDetl.ChlnDelvHead_Idno = RcptHeadIdno;
db.tblChlnDelvDetls.AddObject(objtblChlnDelvDetl);
db.SaveChanges();
}
}
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
Int32 GrIdno = 0;
GrIdno = Convert.ToInt32(Dr["Gr_Idno"]);
TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == GrIdno select obj).FirstOrDefault();
if (objTblGrHead != null)
{
objTblGrHead.Gr_Delv = true;
objTblGrHead.ChlnDelv_Idno = RcptHeadIdno;
db.SaveChanges();
}
}
}
}
}
}
catch (Exception ex)
{
}
return(RcptHeadIdno);
}
public Int64 InsertMtrlRcptHOHead(tblChlnDelvHead objMtrlRcptHOHead, DataTable DtTemp)
{
Int64 RcptHeadIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
tblChlnDelvHead RH = db.tblChlnDelvHeads.Where(rh => (rh.ChlnTransf_Idno == objMtrlRcptHOHead.ChlnTransf_Idno) && (rh.ToCity_Idno == objMtrlRcptHOHead.ToCity_Idno)).FirstOrDefault();
if (RH != null)
{
RcptHeadIdno = -1;
}
else
{
db.tblChlnDelvHeads.AddObject(objMtrlRcptHOHead);
db.SaveChanges();
RcptHeadIdno = objMtrlRcptHOHead.ChlnDelvHead_Idno;
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
// ApplicationFunction.CreateTable("tbl", "Gr_Idno", "String", "Item_Idno", "String", "Unit_Idno", "String", "Rate_Type", "String", "Qty", "Weight", "", "String", "Amount", "String", "Delv_Qty", "String", "Reamrk", "String");
tblChlnDelvDetl objtblChlnDelvDetl = new tblChlnDelvDetl();
objtblChlnDelvDetl.Gr_Idno = Convert.ToInt32(Dr["Gr_Idno"]);
objtblChlnDelvDetl.Item_Idno = Convert.ToInt32(Dr["Item_Idno"]);
objtblChlnDelvDetl.Unit_Idno = Convert.ToInt32(Dr["Unit_Idno"]);
objtblChlnDelvDetl.Rate_Type = Convert.ToInt32(Dr["Rate_Type"]);
objtblChlnDelvDetl.Qty = Convert.ToInt32(Dr["Qty"]);
objtblChlnDelvDetl.Weight = Convert.ToDouble(Dr["Weight"]);
objtblChlnDelvDetl.Amount = Convert.ToDouble(Dr["Amount"]);
objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]);
objtblChlnDelvDetl.Delv_Qty = Convert.ToDouble(Dr["Delv_Qty"]);
objtblChlnDelvDetl.Delv_Weight = Convert.ToDouble(Dr["Delv_Wt"]);
objtblChlnDelvDetl.Delv_Amount = Convert.ToDouble(Dr["Delv_Amount"]);
objtblChlnDelvDetl.Reamrk = Convert.ToString(Dr["Reamrk"]);
objtblChlnDelvDetl.ChlnDelvHead_Idno = RcptHeadIdno;
db.tblChlnDelvDetls.AddObject(objtblChlnDelvDetl);
db.SaveChanges();
}
}
if (DtTemp.Rows.Count > 0)
{
foreach (DataRow Dr in DtTemp.Rows)
{
Int32 GrIdno = 0;
GrIdno = Convert.ToInt32(Dr["Gr_Idno"]);
TblGrHead objTblGrHead = (from obj in db.TblGrHeads where obj.GR_Idno == GrIdno select obj).FirstOrDefault();
if (objTblGrHead != null)
{
objTblGrHead.Gr_Delv = true;
objTblGrHead.ChlnDelv_Idno = RcptHeadIdno;
db.SaveChanges();
}
}
}
}
}
catch
{
return(0);
}
return(RcptHeadIdno);
}
}
protected void lnkBtnSave_Click(object sender, EventArgs e)
{
string msg = string.Empty; bool bflag = false; double IssueQty = 0, IssueWT = 0;
if (grdMain.Rows.Count <= 0)
{
ShowMessage("Please Enter Challan Details");
}
else
{
DtTemp = (DataTable)ViewState["dt"];
DtTemp = CreateDt();
ChallanDelverdDAL objChallanDelverdDAL = new ChallanDelverdDAL();
Int64 MtrlRcptId = 0, MtrlRcptDetlId = 0;
string strMsgTyp = String.Empty;
int yearIdno = Convert.ToInt32(ddlDateRange.SelectedValue);
Int64 Value = 0;
tblChlnDelvHead ObjMtrlRcptHead = new tblChlnDelvHead();
ObjMtrlRcptHead.ChlnDelv_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
ObjMtrlRcptHead.ToCity_Idno = Convert.ToInt32(ddlToCity.SelectedValue);
ObjMtrlRcptHead.ChlnTransf_Idno = Convert.ToInt32(ddlChallanDetl.SelectedValue);
ObjMtrlRcptHead.Date_Added = ApplicationFunction.GetIndianDateTime().Date; // DateTime.Now.Date;
ObjMtrlRcptHead.Date_Modified = ApplicationFunction.GetIndianDateTime().Date;
ObjMtrlRcptHead.ChlnDelv_No = MaxRcptHeadNo(Convert.ToInt32(ddlToCity.SelectedValue), Convert.ToInt32(ddlDateRange.SelectedValue));
ObjMtrlRcptHead.CrsngGR_Amnt = Convert.ToDouble(txtoutGrAmnt.Text);
ObjMtrlRcptHead.LocGR_Amnt = Convert.ToDouble(txtLocGrAmnt.Text);
ObjMtrlRcptHead.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text);
ObjMtrlRcptHead.Year_Idno = Convert.ToInt32(ddlDateRange.SelectedValue);
foreach (GridViewRow row in grdMain.Rows)
{
HiddenField hidGrIdno = (HiddenField)row.FindControl("hidGridno");
HiddenField hidItemidno = (HiddenField)row.FindControl("hidItemidno");
HiddenField hidUnitidno = (HiddenField)row.FindControl("hidUnitidno");
Label lblrateType = (Label)row.FindControl("lblrateType");
Label lblQty = (Label)row.FindControl("lblQty");
Label lblWeight = (Label)row.FindControl("lblWeight");
Label lblAmount = (Label)row.FindControl("lblAmount");
TextBox txtRecQty = (TextBox)row.FindControl("txtRecQty");
TextBox txtRecWT = (TextBox)row.FindControl("txtRecWT");
TextBox txtRecWt = (TextBox)row.FindControl("txtRecWt");
TextBox txtRemark = (TextBox)row.FindControl("txtRemark");
TextBox txtRecAmt = (TextBox)row.FindControl("txtRecAmt");
if (lblrateType.Text == "Rate")
{
if (txtRecQty.Text == "")
{
ShowMessageErr("Please Enter Receiving QTY!");
return;
}
if (Convert.ToDouble(txtRecQty.Text) < 0.00)
{
ShowMessageErr("You Cannot Enter Receiving QTY Less than 1!");
return;
}
IssueQty = Convert.ToDouble(lblQty.Text);
if (IssueQty < Convert.ToDouble(txtRecQty.Text))
{
txtRecQty.Focus();
txtRecQty.Text = "0.00";
ShowMessageErr("You Cannot Enter Receiving QTY more than GR QTY!");
return;
}
}
else
{
if (txtRecWT.Text == "")
{
ShowMessageErr("Please Enter Receiving Weight!");
return;
}
if (Convert.ToDouble(txtRecWT.Text) < 0.00)
{
ShowMessageErr("You Cannot Enter Receiving Weight Less than 1!");
return;
}
IssueWT = Convert.ToDouble(lblWeight.Text);
if (IssueWT < Convert.ToDouble(txtRecWT.Text))
{
txtRecWT.Focus(); txtRecWT.Text = "0.00";
ShowMessageErr("You Cannot Enter Receiving Weight more than GR Weight!");
return;
}
}
ApplicationFunction.DatatableAddRow(DtTemp, hidGrIdno.Value, hidItemidno.Value, hidUnitidno.Value, ((lblrateType.Text) == "Rate") ? "1" : "2", lblQty.Text, lblWeight.Text,
lblAmount.Text, txtRecQty.Text, txtRecWt.Text, txtRecAmt.Text, txtRemark.Text);
}
using (TransactionScope tScope = new TransactionScope(TransactionScopeOption.Required))
{
try
{
ChallanDelverdDAL obj = new ChallanDelverdDAL();
DateTime dMtrlDt = obj.MtrlTransfDate(Convert.ToInt64(ddlChallanDetl.SelectedValue));
hidMtrlTrnsfDt.Value = dMtrlDt.ToString("dd-MM-yyyy");
if (Convert.ToDateTime(ApplicationFunction.mmddyyyy(hidMtrlTrnsfDt.Value)) > Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text)))
{
txtDate.Focus();
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmsg", "PassMessageError('Delivery Date must be greater than or equal to Challan Date [" + dMtrlDt.Date.ToString("dd-MMM-yyyy") + "].')", true);
return;
}
if (string.IsNullOrEmpty(hidMtrlRcptid.Value) == true)
{
MtrlRcptId = obj.InsertMtrlRcptHOHead(ObjMtrlRcptHead, DtTemp);
if (MtrlRcptId > 0)
{
tScope.Complete();
}
}
else
{
tblChlnDelvHead ObjMtrlRcptHeadU = new tblChlnDelvHead();
ObjMtrlRcptHeadU.ChlnDelv_Date = Convert.ToDateTime(ApplicationFunction.mmddyyyy(txtDate.Text));
ObjMtrlRcptHeadU.ToCity_Idno = Convert.ToInt32(ddlToCity.SelectedValue);
ObjMtrlRcptHeadU.ChlnTransf_Idno = Convert.ToInt32(ddlChallanDetl.SelectedValue);
ObjMtrlRcptHeadU.Date_Modified = ApplicationFunction.GetIndianDateTime().Date;
ObjMtrlRcptHeadU.CrsngGR_Amnt = Convert.ToDouble(txtoutGrAmnt.Text);
ObjMtrlRcptHeadU.LocGR_Amnt = Convert.ToDouble(txtLocGrAmnt.Text);
ObjMtrlRcptHeadU.Net_Amnt = Convert.ToDouble(txtNetAmnt.Text);
ObjMtrlRcptHeadU.Year_Idno = Convert.ToInt32(ddlDateRange.SelectedValue);
MtrlRcptId = obj.UpdateMtrlRcptHOHead(ObjMtrlRcptHeadU, DtTemp, Convert.ToInt32(hidMtrlRcptid.Value));
if ((MtrlRcptId > 0))
{
tScope.Complete();
}
}
}
catch (Exception ex)
{
// ApplicationFunction.ErrorLog(ex.ToString());
}
}
if (string.IsNullOrEmpty(hidMtrlRcptid.Value) == true)
{
if (MtrlRcptId > 0)
{
ShowMessage("Record Saved Successffully");
}
}
else
{
if ((MtrlRcptId > 0))
{
ShowMessage("Record Update successfully");
}
}
if (MtrlRcptId == -1)
{
ShowMessage("Challan No. already Delivered !");
bflag = false;
strMsgTyp = "RecExst";
ddlChallanDetl.Focus();
}
else
{
ClearControls();
}
}
}
