public int Delete(Int64 HeadId)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblDelvChlnHead CH = db.tblDelvChlnHeads.Where(h => h.DelvChln_Idno == HeadId).FirstOrDefault();
List <tblDelvChlnDetl> CD = db.tblDelvChlnDetls.Where(d => d.DelvChlnHead_Idno == HeadId).ToList();
if (CH != null)
{
foreach (var d in CD)
{
tblChlnDelvDetl objTblchln = (from obj in db.tblChlnDelvDetls where obj.Gr_Idno == d.GR_Idno select obj).FirstOrDefault();
objTblchln.DelvChlnHead_Idno = 0;
db.SaveChanges();
}
foreach (var d in CD)
{
db.tblDelvChlnDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblDelvChlnHeads.DeleteObject(CH);
// Int64 intValue = objclsAccountPosting.DeleteAccountPosting(HeadId, "CB");
db.SaveChanges();
value = 1;
}
}
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);
}
}
