public int Save(string Name) { int Value = 0; using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required)) { try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { LaneMaster Exsit = db.LaneMasters.Where(c => c.Lane_Name == Name).FirstOrDefault(); if (Exsit == null) { LaneMaster tbl = new LaneMaster(); tbl.Lane_Name = Name; tbl.Date_Added = System.DateTime.Now; db.LaneMasters.AddObject(tbl); db.SaveChanges(); Value = 1; Tran.Complete(); } else { Value = -1; } } } catch (Exception ex) { Value = 0; } } return(Value); }
public int Update(int LaneIdno, string Name) { int Value = 0; using (TransactionScope Tran = new TransactionScope(TransactionScopeOption.Required)) { try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { LaneMaster Exsit = db.LaneMasters.Where(c => c.Lane_Name == Name && c.Lane_Idno != LaneIdno).FirstOrDefault(); //tblMISMast Exsit = db.tblMISMasts.Where(e => e.MIS_Name == Name && e.MIS_Type == Type && e.MIS_Idno != MISId).FirstOrDefault(); if (Exsit == null) { LaneMaster tbl = db.LaneMasters.Where(c => c.Lane_Idno == LaneIdno).FirstOrDefault(); tbl.Lane_Name = Name; tbl.Date_Modified = System.DateTime.Now; db.SaveChanges(); Value = 1; Tran.Complete(); } else { Value = -1; } } } catch (Exception ex) { Value = 0; } } return(Value); }
public LaneMaster SelectByID(int LaneId) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { LaneMaster tbl = db.LaneMasters.Where(t => t.Lane_Idno == LaneId).FirstOrDefault(); return(tbl); } }
public int Delete(int LaneId) { int Value = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { LaneMaster tbl = db.LaneMasters.Where(t => t.Lane_Idno == LaneId).FirstOrDefault(); db.LaneMasters.DeleteObject(tbl); db.SaveChanges(); Value = 1; } } catch (Exception ex) { Value = 0; } return(Value); }