public int DeleteQuotation(Int64 HeadId, Int64 UserIdno, string con)
{
int value = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblQuatationHead qth = db.tblQuatationHeads.Where(h => h.QuHead_Idno == HeadId).FirstOrDefault();
List <tblQuatationDetl> qtd = db.tblQuatationDetls.Where(d => d.QuHead_Idno == HeadId).ToList();
if (qth != null)
{
SqlParameter[] objSqlPara = new SqlParameter[3];
objSqlPara[0] = new SqlParameter("@Action", "DeleteQuotationDet");
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 qtd)
{
db.tblQuatationDetls.DeleteObject(d);
db.SaveChanges();
}
db.tblQuatationHeads.DeleteObject(qth);
db.SaveChanges();
value = 1;
}
}
return(value);
}
public Int64 Insert(tblQuatationHead QtnHead, List <tblQuatationDetl> QtnDetl)
{
Int64 QtnHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblQuatationHead QH = db.tblQuatationHeads.Where(qh => qh.QuHead_No == QtnHead.QuHead_No && qh.Year_Idno == QtnHead.Year_Idno).FirstOrDefault();
if (QH != null)
{
QtnHeadId = -1;
}
else
{
db.tblQuatationHeads.AddObject(QtnHead);
db.SaveChanges();
QtnHeadId = QtnHead.QuHead_Idno;
if (QtnDetl.Count > 0)
{
foreach (tblQuatationDetl qtd in QtnDetl)
{
qtd.QuHead_Idno = QtnHeadId;
db.tblQuatationDetls.AddObject(qtd);
db.SaveChanges();
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(QtnHeadId);
}
public Int64 Update(tblQuatationHead QtnHead, List <tblQuatationDetl> QtnDetl)
{
Int64 QtnHeadId = 0;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
db.Connection.Open();
using (DbTransaction dbTran = db.Connection.BeginTransaction())
{
try
{
tblQuatationHead QH = db.tblQuatationHeads.Where(qh => qh.QuHead_No == QtnHead.QuHead_No && qh.QuHead_Idno != QtnHead.QuHead_Idno).FirstOrDefault();
if (QH != null)
{
QtnHeadId = -1;
}
else
{
tblQuatationHead qtn = db.tblQuatationHeads.Where(qh => qh.QuHead_Idno == QtnHead.QuHead_Idno).FirstOrDefault();
if (qtn != null)
{
//qtn.Chln_Idno = QtnHead.Chln_Idno;
qtn.Date_Modified = DateTime.Now;
qtn.DelvryPlce_Idno = QtnHead.DelvryPlce_Idno;
qtn.FromCity_Idno = QtnHead.FromCity_Idno;
qtn.QuHead_Date = QtnHead.QuHead_Date;
qtn.QuHead_No = QtnHead.QuHead_No;
qtn.Sender_Idno = QtnHead.Sender_Idno;
qtn.ToCity_Idno = QtnHead.ToCity_Idno;
qtn.QuHead_Typ = QtnHead.QuHead_Typ;
qtn.RndOff_Amnt = QtnHead.RndOff_Amnt;
qtn.Gross_Amnt = QtnHead.Gross_Amnt;
qtn.Other_Amnt = QtnHead.Other_Amnt;
qtn.Net_Amnt = QtnHead.Net_Amnt;
qtn.Year_Idno = QtnHead.Year_Idno;
qtn.Remark = QtnHead.Remark;
db.SaveChanges();
QtnHeadId = QtnHead.QuHead_Idno;
List <tblQuatationDetl> QtnDel = db.tblQuatationDetls.Where(qnd => qnd.QuHead_Idno == QtnHead.QuHead_Idno).ToList();
foreach (tblQuatationDetl qtd1 in QtnDel)
{
db.tblQuatationDetls.DeleteObject(qtd1);
db.SaveChanges();
}
foreach (tblQuatationDetl qtd1 in QtnDetl)
{
qtd1.QuHead_Idno = QtnHeadId;
db.tblQuatationDetls.AddObject(qtd1);
db.SaveChanges();
}
dbTran.Commit();
}
}
}
catch
{
dbTran.Rollback();
}
}
}
return(QtnHeadId);
}
