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