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); }