public Int64 Insert(tblClaimToComHead obj, DataTable Dttemp)
{
Int64 ClaimToComHeadIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblClaimToComHead Claimhead = new tblClaimToComHead();
try
{
tblClaimToComHead CH = db.tblClaimToComHeads.Where(ch => ch.ClaimToCom_No == obj.ClaimToCom_No && ch.Prefix_No == obj.Prefix_No && ch.FromLoc_Idno == obj.FromLoc_Idno && ch.Year_Idno == obj.Year_Idno).FirstOrDefault();
if (CH != null)
{
ClaimToComHeadIdno = -1;
}
else
{
db.tblClaimToComHeads.AddObject(obj);
db.SaveChanges();
ClaimToComHeadIdno = obj.ClaimToComHead_Idno;
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
tblClaimToComDetl objtblClaimDetl = new tblClaimToComDetl();
objtblClaimDetl.ClaimToComHead_Idno = ClaimToComHeadIdno;
objtblClaimDetl.StckDetl_Idno = Convert.ToInt64(Dr["SerialIdno"]);
objtblClaimDetl.ClaimToHead_Idno = Convert.ToInt64(Dr["ClaimIdno"]);
objtblClaimDetl.Defect_Remark = Convert.ToString(Dr["DefectRemark"]);
objtblClaimDetl.VechApp_Details = Convert.ToString(Dr["VechAppDetails"]);
objtblClaimDetl.Status = Convert.ToInt64(Dr["Status"]);
objtblClaimDetl.Remark = Convert.ToString(Dr["Remark"]);
objtblClaimDetl.New_SerialNo = Convert.ToString(Dr["NewSerialNo"]);
db.tblClaimToComDetls.AddObject(objtblClaimDetl);
Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == objtblClaimDetl.StckDetl_Idno).FirstOrDefault();
SD.Claim_Status = 1;
db.SaveChanges();
}
}
}
}
catch
{
ClaimToComHeadIdno = 0;
}
return(ClaimToComHeadIdno);
}
}
public Int64 Update(tblClaimToComHead obj, Int32 Head_Idno, DataTable Dttemp)
{
Int64 ClaimHeadIdno = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblClaimToComHead CH = db.tblClaimToComHeads.Where(ch => ch.ClaimToCom_No == obj.ClaimToCom_No && ch.ClaimToComHead_Idno != Head_Idno && ch.Against == obj.Against && ch.FromLoc_Idno == obj.FromLoc_Idno && ch.Year_Idno == obj.Year_Idno).FirstOrDefault();
if (CH != null)
{
ClaimHeadIdno = -1;
}
else
{
tblClaimToComHead CHead = db.tblClaimToComHeads.Where(ch => ch.ClaimToComHead_Idno == Head_Idno).FirstOrDefault();
if (CHead != null)
{
db.SaveChanges();
ClaimHeadIdno = CHead.ClaimToComHead_Idno;
List <tblClaimToComDetl> ClaimDetl = db.tblClaimToComDetls.Where(cd => cd.ClaimToHead_Idno == Head_Idno).ToList();
foreach (tblClaimToComDetl tcd in ClaimDetl)
{
db.tblClaimToComDetls.DeleteObject(tcd);
Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == tcd.StckDetl_Idno).FirstOrDefault();
SD.Claim_Status = 1;
db.SaveChanges();
}
if (Dttemp != null && Dttemp.Rows.Count > 0)
{
foreach (DataRow Dr in Dttemp.Rows)
{
tblClaimToComDetl objtblClaimDetl = new tblClaimToComDetl();
objtblClaimDetl.ClaimToComHead_Idno = ClaimHeadIdno;
objtblClaimDetl.StckDetl_Idno = Convert.ToInt64(Dr["SerialIdno"]);
objtblClaimDetl.ClaimToHead_Idno = Convert.ToInt64(Dr["ClaimIdno"]);
objtblClaimDetl.Defect_Remark = Convert.ToString(Dr["DefectRemark"]);
objtblClaimDetl.VechApp_Details = Convert.ToString(Dr["VechAppDetails"]);
objtblClaimDetl.Status = Convert.ToInt64(Dr["Status"]);
objtblClaimDetl.Remark = Convert.ToString(Dr["Remark"]);
objtblClaimDetl.New_SerialNo = Convert.ToString(Dr["NewSerialNo"]);
db.tblClaimToComDetls.AddObject(objtblClaimDetl);
Stckdetl SD = db.Stckdetls.Where(d => d.SerlDetl_id == objtblClaimDetl.StckDetl_Idno).FirstOrDefault();
SD.Claim_Status = 1;
db.SaveChanges();
}
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(ClaimHeadIdno);
}
