public Int64 Update(DateTime?AlignDate, string LorryNo) { Int64 intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AlignDate_SMS objSMSAlign = (from mast in db.AlignDate_SMS where mast.AlignDate == AlignDate && mast.LorryNo == LorryNo select mast).FirstOrDefault(); if (objSMSAlign != null) { objSMSAlign.Status = true; db.SaveChanges(); intValue = objSMSAlign.ID; } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }
public Int64 Insert(string msg, DateTime?AlignDate, DateTime?PrevAlignDate, string LorryNo) { Int64 intValue = 0; try { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AlignDate_SMS objSMSAlign = new AlignDate_SMS(); objSMSAlign.Message = msg; objSMSAlign.AlignDate = AlignDate; objSMSAlign.PrevAlignDate = PrevAlignDate; objSMSAlign.LorryNo = LorryNo; objSMSAlign.Status = false; objSMSAlign.DateModified = System.DateTime.Now; if (IsExists(LorryNo, AlignDate) == true) { intValue = -1; } else { db.AlignDate_SMS.AddObject(objSMSAlign); db.SaveChanges(); intValue = objSMSAlign.ID; } } } catch (Exception ex) { //ApplicationFunction.ErrorLog(ex.ToString()); } return(intValue); }
public bool IsExists(string LorryNo, DateTime?AlignDate) { using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString())) { AlignDate_SMS obj = new AlignDate_SMS(); obj = (from mast in db.AlignDate_SMS where mast.LorryNo == LorryNo && mast.AlignDate == AlignDate select mast).FirstOrDefault(); if (obj != null) { return(true); } else { return(false); } } }