public int ProcessScheduleDataUpdate(Prb_ScheduleRequest request) { ProbeDBEntities _Db = DBHelper.Instance._Db;; try { Prb_SiteResponse response = new Prb_SiteResponse(); var _Prb_Schedule = (from s in _Db.Prb_Schedule where s.ScheduleId == request.Prb_Schedule.ScheduleId && s.IsDeleted == false select s).FirstOrDefault(); if (_Prb_Schedule != null) { _Prb_Schedule.StatusId = request.Prb_Schedule.StatusId; _Prb_Schedule.EndDateTime = request.Prb_Schedule.EndDateTime; _Prb_Schedule.ModifiedBy = 1; _Prb_Schedule.ModifiedDate = DateTime.Now; _Db.SaveChanges(); } return(Convert.ToInt32(_Prb_Schedule.ScheduleId.ToString())); } catch (Exception ex) { // throw ex; return(0); } }
public IQueryable <Prb_SiteDTO> GetSiteData() { ProbeDBEntities _Db = DBHelper.Instance._Db;; Prb_SiteResponse response = new Prb_SiteResponse(); Prb_SiteDTO prb_SiteDTO = new Prb_SiteDTO(); var Prb_SiteTemp = (from s in _Db.Prb_Site where s.IsActive == true && s.IsDeleted == false select new { SiteId = s.SiteId, CustomerName = s.CustomerName, Description = s.Description, IsActive = s.IsActive } ); var Prb_Site = Prb_SiteTemp.ToList().Select(s => new Prb_SiteDTO() { SiteId = Convert.ToInt32(s.SiteId.ToString()), CustomerName = s.CustomerName, Description = s.Description, IsActive = s.IsActive } ).AsQueryable(); return(Prb_Site); }
// Wrriten by waheed public Prb_SiteResponse GetSiteData_Waheed() { Prb_SiteResponse response = new Prb_SiteResponse(); try { //using (DbCommand dbCommand = PrbDataBase.GetStoredProcCommand(DBConstant.Prb_Site.SP_PRB_SITE)) //{ // PrbDataBase.AddInParameter(dbCommand, "@OperationId", DbType.Int32, 1); // DataSet ds = PrbDataBase.ExecuteDataSet(dbCommand); // if (ds.Tables != null && ds.Tables.Count > 0) // { // response.Prb_SiteList = MapDataTableToList<Prb_SiteDTO>(ds.Tables[0]).ToList(); // } //} return(response); } catch (Exception ex) { throw ex; } }
public long ProcessScheduleDataGet(Prb_ScheduleRequest request) { ProbeDBEntities _Db = DBHelper.Instance._Db;; try { Prb_SiteResponse response = new Prb_SiteResponse(); var _Prb_ScheduleTemp = (from s in _Db.Prb_Schedule where s.ScheduleId == request.Prb_Schedule.ScheduleId && s.IsDeleted == false select new { SiteId = s.SiteId, ScheduleId = s.ScheduleId, Description = s.Description, StartDateTime = s.StartDateTime, EndDateTime = s.EndDateTime, StatusId = s.StatusId, } ); var _Prb_Schedule = _Prb_ScheduleTemp.ToList().Select(prb => new Prb_ScheduleDTO() { SiteId = Convert.ToInt32(prb.SiteId.ToString()), ScheduleId = Convert.ToInt32(prb.ScheduleId.ToString()), Description = prb.Description, StartDateTime = prb.StartDateTime, EndDateTime = prb.EndDateTime, StatusId = Convert.ToInt32(prb.StatusId.ToString()), } ).AsQueryable(); return(_Prb_Schedule.Select(x => x.ScheduleId).FirstOrDefault()); } catch (Exception ex) { throw ex; // return 0; } }