public int DeleteReceiptGoods(Int64 HeadId, Int64 UserIdno, string con)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblRcptGoodHead rgh = db.tblRcptGoodHeads.Where(h => h.RcptGoodHead_Idno == HeadId).FirstOrDefault();
List <tblRcptGoodDetl> rgd = db.tblRcptGoodDetls.Where(d => d.RcptGoodHead_Idno == HeadId).ToList();
if (rgh != null)
{
SqlParameter[] objSqlPara = new SqlParameter[3];
objSqlPara[0] = new SqlParameter("@Action", "DeleteReceiptGoodsRecvd");
objSqlPara[1] = new SqlParameter("@Idno", HeadId);
objSqlPara[2] = new SqlParameter("@UserIdno", UserIdno);
Int32 del = SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "spDeleteFunctionality", objSqlPara);
foreach (var d in rgd)
{
db.tblRcptGoodDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblRcptGoodHeads.DeleteObject(rgh);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public Int64 Update(tblRcptGoodHead rcptGoodHead, List <tblRcptGoodDetl> rcptGoodDetl)
{
Int64 RcptGoodHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblRcptGoodHead RH = db.tblRcptGoodHeads.Where(rh => rh.RcptGoodHead_No == rcptGoodHead.RcptGoodHead_No && rh.FromCity_Idno == rcptGoodHead.FromCity_Idno && rh.Year_Idno == rcptGoodHead.Year_Idno && rh.RcptGoodHead_Idno != rcptGoodHead.RcptGoodHead_Idno).FirstOrDefault();
if (RH != null)
{
RcptGoodHeadId = -1;
}
else
{
tblRcptGoodHead rgh = db.tblRcptGoodHeads.Where(rh => rh.RcptGoodHead_Idno == rcptGoodHead.RcptGoodHead_Idno).FirstOrDefault();
if (rgh != null)
{
rgh.Agent_Idno = rcptGoodHead.Agent_Idno;
rgh.Date_Modified = DateTime.Now;
rgh.DelvryPlc_Idno = rcptGoodHead.DelvryPlc_Idno;
rgh.FromCity_Idno = rcptGoodHead.FromCity_Idno;
rgh.GRHead_Idno = rcptGoodHead.GRHead_Idno;
rgh.RcptGoodHead_Date = rcptGoodHead.RcptGoodHead_Date;
rgh.RcptGoodHead_No = rcptGoodHead.RcptGoodHead_No;
rgh.Recevr_Idno = rcptGoodHead.Recevr_Idno;
rgh.Sender_Idno = rcptGoodHead.Sender_Idno;
rgh.ToCity_Idno = rcptGoodHead.ToCity_Idno;
rgh.Sender_No = rcptGoodHead.Sender_No;
rgh.Year_Idno = rcptGoodHead.Year_Idno;
db.SaveChanges();
RcptGoodHeadId = rcptGoodHead.RcptGoodHead_Idno;
List <tblRcptGoodDetl> rcptdetl = db.tblRcptGoodDetls.Where(rd => rd.RcptGoodHead_Idno == rcptGoodHead.RcptGoodHead_Idno).ToList();
foreach (tblRcptGoodDetl rgd in rcptdetl)
{
db.tblRcptGoodDetls.DeleteObject(rgd);
db.SaveChanges();
}
foreach (tblRcptGoodDetl rgd in rcptGoodDetl)
{
rgd.RcptGoodHead_Idno = RcptGoodHeadId;
db.tblRcptGoodDetls.AddObject(rgd);
db.SaveChanges();
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(RcptGoodHeadId);
}
public Int64 Insert(tblRcptGoodHead rcptGoodHead, List <tblRcptGoodDetl> rcptGoodDetl)
{
Int64 RcptGoodHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblRcptGoodHead RH = db.tblRcptGoodHeads.Where(rh => rh.RcptGoodHead_No == rcptGoodHead.RcptGoodHead_No && rh.FromCity_Idno == rcptGoodHead.FromCity_Idno && rh.Year_Idno == rcptGoodHead.Year_Idno).FirstOrDefault();
if (RH != null)
{
RcptGoodHeadId = -1;
}
else
{
db.tblRcptGoodHeads.AddObject(rcptGoodHead);
db.SaveChanges();
RcptGoodHeadId = rcptGoodHead.RcptGoodHead_Idno;
if (rcptGoodDetl.Count > 0)
{
foreach (tblRcptGoodDetl rgd in rcptGoodDetl)
{
rgd.RcptGoodHead_Idno = RcptGoodHeadId;
db.tblRcptGoodDetls.AddObject(rgd);
db.SaveChanges();
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(RcptGoodHeadId);
}
