//public virtual string CoCoRaHSDoAddChanges()
//{
// try
// {
// CoCoRaHSdb.SaveChanges();
// }
// catch (Exception ex)
// {
// return string.Format(ServiceRes.CouldNotAddError_, ex.Message);
// }
// return "";
//}
//public virtual string CoCoRaHSDoDeleteChanges()
//{
// try
// {
// CoCoRaHSdb.SaveChanges();
// }
// catch (Exception ex)
// {
// return string.Format(ServiceRes.CouldNotDeleteError_, ex.Message);
// }
// return "";
//}
//public virtual string CoCoRaHSDoUpdateChanges()
//{
// try
// {
// CoCoRaHSdb.SaveChanges();
// }
// catch (Exception ex)
// {
// return string.Format(ServiceRes.CouldNotUpdateError_, ex.Message);
// }
// return "";
//}
public virtual string DoAddChanges()
{
try
{
db.SaveChanges();
}
catch (Exception ex)
{
return(string.Format(ServiceRes.CouldNotAddError_, ex.Message));
}
return("");
}
public TVItemModel MarkSamplesWithMWQMSampleIDForOpenDataDB(int MWQMSampleID, bool UseForOpenData)
{
using (CSSPDBEntities dd = new CSSPDBEntities())
{
MWQMSample mwqmSample = (from s in dd.MWQMSamples
where s.MWQMSampleID == MWQMSampleID
select s).FirstOrDefault();
if (mwqmSample == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.MWQMSample, ServiceRes.MWQMSampleID, MWQMSampleID.ToString())));
}
mwqmSample.UseForOpenData = UseForOpenData;
try
{
dd.SaveChanges();
}
catch (Exception ex)
{
return(ReturnError(string.Format(ServiceRes.CouldNotUpdateError_, ex.Message + " InnerException: " + (ex.InnerException != null ? ex.InnerException.Message : ""))));
}
}
return(ReturnError(""));
}
public TVItemModel ToggleUseForOpenDataFlagOfAllSamplesUnderMWQMSiteTVItemIDDB(int MWQMSiteTVItemID, DateTime StartDate, DateTime EndDate, bool UseForOpenData)
{
string RoutineTxt = ((int)SampleTypeEnum.Routine).ToString() + ",";
TVItem tvItemSite = new TVItem();
using (CSSPDBEntities dd = new CSSPDBEntities())
{
tvItemSite = (from c in dd.TVItems
where c.TVItemID == MWQMSiteTVItemID
select c).FirstOrDefault();
}
if (tvItemSite == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.MWQMSite, ServiceRes.MWQMSiteTVItemID, MWQMSiteTVItemID.ToString())));
}
using (CSSPDBEntities dd = new CSSPDBEntities())
{
List <MWQMSample> mwqmSampleList = (from t in dd.TVItems
from s in dd.MWQMSamples
where t.TVItemID == s.MWQMSiteTVItemID &&
t.TVItemID == MWQMSiteTVItemID &&
t.TVType == (int)TVTypeEnum.MWQMSite &&
s.SampleTypesText.Contains(RoutineTxt) &&
s.UseForOpenData == !UseForOpenData &&
s.SampleDateTime_Local >= StartDate &&
s.SampleDateTime_Local <= EndDate
select s).ToList();
foreach (MWQMSample mwqmSample in mwqmSampleList)
{
mwqmSample.UseForOpenData = UseForOpenData;
}
try
{
dd.SaveChanges();
}
catch (Exception ex)
{
return(ReturnError(string.Format(ServiceRes.CouldNotUpdateError_, ex.Message + " InnerException: " + (ex.InnerException != null ? ex.InnerException.Message : ""))));
}
}
return(ReturnError(""));
}