public Int64 MatUpdate(Int64 intGRIdno, DateTime?dtMat_Date, Int32 IAgainst, Int64 intMat_No, Int32 intLoc_Idno, Int32 TruckNoIdno, Double DNetAmnt, Int32 YearIdno, DataTable dtDetail, Int32 intIssueTo, string strRemark, Int64 DriverIdno)
{
Int64 intGrIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
TyreIssHead objGRHead = db.TyreIssHeads.Where(rh => (rh.MatIss_Idno != intGRIdno) && (rh.MatIss_No == intMat_No) && (rh.Loc_Idno == intLoc_Idno) && (rh.Year_Idno == YearIdno)).FirstOrDefault();
if (objGRHead == null)
{
TyreIssHead objMatIssHead1 = db.TyreIssHeads.Where(rh => rh.MatIss_Idno == intGRIdno).FirstOrDefault();
if (objMatIssHead1 != null)
{
objMatIssHead1.MatIss_Date = dtMat_Date;
objMatIssHead1.MatIss_Typ = IAgainst;
objMatIssHead1.MatIss_No = intMat_No;
objMatIssHead1.Loc_Idno = intLoc_Idno;
objMatIssHead1.Truck_Idno = TruckNoIdno;
objMatIssHead1.Net_Amnt = DNetAmnt;
objMatIssHead1.Year_Idno = YearIdno;
objMatIssHead1.Issue_To = intIssueTo;
objMatIssHead1.ReMark = strRemark;
objMatIssHead1.Date_Modified = System.DateTime.Now;
objMatIssHead1.Mat_Frm = "BK";
objMatIssHead1.Driver_Idno = DriverIdno;
db.SaveChanges();
intGrIdno = objMatIssHead1.MatIss_Idno;
if (intGrIdno > 0)
{
List <TyreIssDetl> lstGrDetl = db.TyreIssDetls.Where(obj => obj.MatIssHead_Idno == intGrIdno).ToList();
if (lstGrDetl.Count > 0)
{
foreach (TyreIssDetl obj in lstGrDetl)
{
db.TyreIssDetls.DeleteObject(obj);
}
db.SaveChanges();
}
List <Stckdetl> ObjStckDetl = db.Stckdetls.Where(h => h.MtrlIssue_Idno == intGrIdno).ToList();
if (ObjStckDetl != null)
{
foreach (var b in ObjStckDetl)
{
b.MtrlIssue_Idno = 0;
b.Is_Issued = false;
db.SaveChanges();
}
}
foreach (DataRow row in dtDetail.Rows)
{
Int64 StckDetlIdno = Convert.ToInt64(row["StckDetl_Idno"]);
Stckdetl objStckDetl = db.Stckdetls.Where(r => r.SerlDetl_id == StckDetlIdno).SingleOrDefault();
objStckDetl.MtrlIssue_Idno = Convert.ToInt64(intGrIdno);
objStckDetl.Is_Issued = true;
TyreIssDetl objMatIssDetl = new TyreIssDetl();
objMatIssDetl.MatIssHead_Idno = Convert.ToInt64(intGrIdno);
objMatIssDetl.Iteam_Idno = Convert.ToInt32(row["Item_Idno"]);
objMatIssDetl.Item_Qty = Convert.ToInt64(row["Quantity"]);
objMatIssDetl.Item_Weght = Convert.ToDouble(row["Weight"]);
objMatIssDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objMatIssDetl.Item_Amnt = Convert.ToDouble(row["Amount"]);
objMatIssDetl.Remark = Convert.ToString(row["Detail"]);
objMatIssDetl.StckDetl_Idno = Convert.ToInt64(row["StckDetl_Idno"]);
db.TyreIssDetls.AddObject(objMatIssDetl);
db.SaveChanges();
}
}
}
}
else
{
intGrIdno = -1;
}
}
catch (Exception Ex)
{
intGrIdno = 0;
}
}
return(intGrIdno);
}
public Int64 InsertMat(DateTime?dtMat_Date, Int32 IAgainst, Int64 intMat_No, Int32 intLoc_Idno, Int32 TruckNoIdno, Double DNetAmnt, Int32 YearIdno, DataTable dtDetail, Int32 intIssueTo, string strRemark, Int64 DriverIdno)
{
Int64 intMateIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
try
{
TyreIssHead objMatHead = db.TyreIssHeads.Where(rh => (rh.MatIss_No == intMat_No) && (rh.Loc_Idno == intLoc_Idno) && (rh.Year_Idno == YearIdno)).FirstOrDefault();
if (objMatHead == null)
{
objMatHead = new TyreIssHead();
objMatHead.MatIss_Date = dtMat_Date;
objMatHead.MatIss_Typ = IAgainst;
objMatHead.MatIss_No = intMat_No;
objMatHead.Loc_Idno = intLoc_Idno;
objMatHead.Truck_Idno = TruckNoIdno;
objMatHead.Net_Amnt = DNetAmnt;
objMatHead.Year_Idno = YearIdno;
objMatHead.Issue_To = intIssueTo;
objMatHead.ReMark = strRemark;
objMatHead.Date_Added = System.DateTime.Now;
objMatHead.Mat_Frm = "BK";
objMatHead.Driver_Idno = DriverIdno;
db.TyreIssHeads.AddObject(objMatHead);
db.SaveChanges();
intMateIdno = objMatHead.MatIss_Idno;
if (intMateIdno > 0)
{
foreach (DataRow row in dtDetail.Rows)
{
Int64 StckDetlIdno = Convert.ToInt64(row["StckDetl_Idno"]);
Stckdetl objStckDetl = db.Stckdetls.Where(r => r.SerlDetl_id == StckDetlIdno).SingleOrDefault();
objStckDetl.MtrlIssue_Idno = Convert.ToInt64(intMateIdno);
objStckDetl.Is_Issued = true;
TyreIssDetl objMatDetl = new TyreIssDetl();
objMatDetl.MatIssHead_Idno = Convert.ToInt64(intMateIdno);
objMatDetl.Iteam_Idno = Convert.ToInt32(row["Item_Idno"]);
objMatDetl.Item_Qty = Convert.ToInt64(row["Quantity"]);
objMatDetl.Item_Weght = Convert.ToDouble(row["Weight"]);
objMatDetl.Item_Rate = Convert.ToDouble(row["Rate"]);
objMatDetl.Item_Amnt = Convert.ToDouble(row["Amount"]);
objMatDetl.Remark = Convert.ToString(row["Detail"]);
objMatDetl.StckDetl_Idno = Convert.ToInt64(row["StckDetl_Idno"]);
db.TyreIssDetls.AddObject(objMatDetl);
db.SaveChanges();
}
// tScope.Complete();
}
}
else
{
intMateIdno = -1;
}
}
catch (Exception Ex)
{
intMateIdno = 0;
}
}
return(intMateIdno);
}
