public SamplingPlanSubsectorSiteModel GetSamplingPlanSubsectorSiteModelWithSamplingPlanSubsectorSiteIDDB(int SamplingPlanSubsectorSiteID)
{
SamplingPlanSubsectorSiteModel SamplingPlanSubsectorSiteModel = (from c in db.SamplingPlanSubsectorSites
let mwqmSiteTVText = (from p in db.TVItemLanguages where c.MWQMSiteTVItemID == p.TVItemID select p.TVText).FirstOrDefault()
where c.SamplingPlanSubsectorSiteID == SamplingPlanSubsectorSiteID
orderby c.SamplingPlanSubsectorSiteID
select new SamplingPlanSubsectorSiteModel
{
Error = "",
SamplingPlanSubsectorSiteID = c.SamplingPlanSubsectorSiteID,
DBCommand = (DBCommandEnum)c.DBCommand,
SamplingPlanSubsectorID = c.SamplingPlanSubsectorID,
MWQMSiteTVItemID = c.MWQMSiteTVItemID,
MWQMSiteText = mwqmSiteTVText,
IsDuplicate = c.IsDuplicate,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <SamplingPlanSubsectorSiteModel>();
if (SamplingPlanSubsectorSiteModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.SamplingPlanSubsectorSite, ServiceRes.SamplingPlanSubsectorSiteID, SamplingPlanSubsectorSiteID)));
}
return(SamplingPlanSubsectorSiteModel);
}
// Post
public SamplingPlanSubsectorSiteModel PostAddSamplingPlanSubsectorSiteDB(SamplingPlanSubsectorSiteModel samplingPlanSubsectorSiteModel)
{
string retStr = SamplingPlanSubsectorSiteModelOK(samplingPlanSubsectorSiteModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
SamplingPlanSubsectorSiteModel SamplingPlanSubsectorSiteModelExist = GetSamplingPlanSubsectorSiteModelExistDB(samplingPlanSubsectorSiteModel);
if (string.IsNullOrWhiteSpace(SamplingPlanSubsectorSiteModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.SamplingPlanSubsectorSite)));
}
SamplingPlanSubsectorSite SamplingPlanSubsectorSiteNew = new SamplingPlanSubsectorSite();
retStr = FillSamplingPlanSubsectorSite(SamplingPlanSubsectorSiteNew, samplingPlanSubsectorSiteModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.SamplingPlanSubsectorSites.Add(SamplingPlanSubsectorSiteNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("SamplingPlanSubsectorSites", SamplingPlanSubsectorSiteNew.SamplingPlanSubsectorSiteID, LogCommandEnum.Add, SamplingPlanSubsectorSiteNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetSamplingPlanSubsectorSiteModelWithSamplingPlanSubsectorSiteIDDB(SamplingPlanSubsectorSiteNew.SamplingPlanSubsectorSiteID));
}
public SamplingPlanSubsectorSiteModel PostUpdateSamplingPlanSubsectorSiteDB(SamplingPlanSubsectorSiteModel samplingPlanSubsectorSiteModel)
{
string retStr = SamplingPlanSubsectorSiteModelOK(samplingPlanSubsectorSiteModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
SamplingPlanSubsectorSite SamplingPlanSubsectorSiteToUpdate = GetSamplingPlanSubsectorSiteWithSamplingPlanSubsectorSiteIDDB(samplingPlanSubsectorSiteModel.SamplingPlanSubsectorSiteID);
if (SamplingPlanSubsectorSiteToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.SamplingPlanSubsectorSite)));
}
retStr = FillSamplingPlanSubsectorSite(SamplingPlanSubsectorSiteToUpdate, samplingPlanSubsectorSiteModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("SamplingPlanSubsectorSites", SamplingPlanSubsectorSiteToUpdate.SamplingPlanSubsectorSiteID, LogCommandEnum.Change, SamplingPlanSubsectorSiteToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetSamplingPlanSubsectorSiteModelWithSamplingPlanSubsectorSiteIDDB(SamplingPlanSubsectorSiteToUpdate.SamplingPlanSubsectorSiteID));
}
// Check
public string SamplingPlanSubsectorSiteModelOK(SamplingPlanSubsectorSiteModel samplingPlanSubsectorSiteModel)
{
string retStr = FieldCheckNotZeroInt(samplingPlanSubsectorSiteModel.SamplingPlanSubsectorID, ServiceRes.SamplingPlanSubsectorID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotZeroInt(samplingPlanSubsectorSiteModel.MWQMSiteTVItemID, ServiceRes.MWQMSiteTVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(samplingPlanSubsectorSiteModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
// Fill
public string FillSamplingPlanSubsectorSite(SamplingPlanSubsectorSite samplingPlanSubsectorSite, SamplingPlanSubsectorSiteModel samplingPlanSubsectorSiteModel, ContactOK contactOK)
{
samplingPlanSubsectorSite.DBCommand = (int)samplingPlanSubsectorSiteModel.DBCommand;
samplingPlanSubsectorSite.SamplingPlanSubsectorID = samplingPlanSubsectorSiteModel.SamplingPlanSubsectorID;
samplingPlanSubsectorSite.MWQMSiteTVItemID = samplingPlanSubsectorSiteModel.MWQMSiteTVItemID;
samplingPlanSubsectorSite.IsDuplicate = samplingPlanSubsectorSiteModel.IsDuplicate;
samplingPlanSubsectorSite.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
samplingPlanSubsectorSite.LastUpdateContactTVItemID = 2;
}
else
{
samplingPlanSubsectorSite.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
