public SamplingPlanSubsectorModel GetSamplingPlanSubsectorModelWithSamplingPlanIDAndSubsectorTVItemIDDB(int SamplingPlanID, int SubsectorTVItemID)
{
SamplingPlanSubsectorModel SamplingPlanSubsectorModel = (from c in db.SamplingPlanSubsectors
let subsectorTVText = (from p in db.TVItemLanguages where c.SubsectorTVItemID == p.TVItemID select p.TVText).FirstOrDefault()
let siteCount = (from p in db.SamplingPlanSubsectorSites where c.SamplingPlanSubsectorID == p.SamplingPlanSubsectorID select p).Count()
where c.SamplingPlanID == SamplingPlanID &&
c.SubsectorTVItemID == SubsectorTVItemID
select new SamplingPlanSubsectorModel
{
Error = "",
SamplingPlanSubsectorID = c.SamplingPlanSubsectorID,
DBCommand = (DBCommandEnum)c.DBCommand,
SamplingPlanID = c.SamplingPlanID,
SubsectorTVItemID = c.SubsectorTVItemID,
SubsectorTVText = subsectorTVText,
SiteCount = siteCount,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <SamplingPlanSubsectorModel>();
if (SamplingPlanSubsectorModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.SamplingPlanSubsector, ServiceRes.SamplingPlanID + "," + ServiceRes.SubsectorTVItemID, SamplingPlanID + "," + SubsectorTVItemID)));
}
return(SamplingPlanSubsectorModel);
}
// Post
public SamplingPlanSubsectorModel PostAddSamplingPlanSubsectorDB(SamplingPlanSubsectorModel SamplingPlanSubsectorModel)
{
string retStr = SamplingPlanSubsectorModelOK(SamplingPlanSubsectorModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
SamplingPlanSubsectorModel SamplingPlanSubsectorModelExist = GetSamplingPlanSubsectorModelExistDB(SamplingPlanSubsectorModel);
if (string.IsNullOrWhiteSpace(SamplingPlanSubsectorModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.SamplingPlanSubsector)));
}
SamplingPlanSubsector SamplingPlanSubsectorNew = new SamplingPlanSubsector();
retStr = FillSamplingPlanSubsector(SamplingPlanSubsectorNew, SamplingPlanSubsectorModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.SamplingPlanSubsectors.Add(SamplingPlanSubsectorNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("SamplingPlanSubsectors", SamplingPlanSubsectorNew.SamplingPlanSubsectorID, LogCommandEnum.Add, SamplingPlanSubsectorNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetSamplingPlanSubsectorModelWithSamplingPlanSubsectorIDDB(SamplingPlanSubsectorNew.SamplingPlanSubsectorID));
}
public PartialViewResult _SamplingPlanMWQMSites(int SamplingPlanID, int ProvinceTVItemID, int SubsectorTVItemID)
{
ViewBag.SamplingPlanID = SamplingPlanID;
ViewBag.ProvinceTVItemID = ProvinceTVItemID;
ViewBag.SubsectorTVItemID = SubsectorTVItemID;
ViewBag.SamplingPlanSubsectorSiteModelList = null;
ViewBag.TVItemModelMWQMSiteList = null;
ViewBag.AdminContactModelList = null;
ViewBag.IsSamplingPlanner = null;
ViewBag.ContactModel = null;
ContactModel contactModel = _ContactService.GetContactLoggedInDB();
ViewBag.ContactModel = contactModel;
bool IsSamplingPlanner = false;
if (contactModel.SamplingPlanner_ProvincesTVItemID.Contains(ProvinceTVItemID.ToString()))
{
IsSamplingPlanner = true;
}
else
{
List <ContactModel> adminContactModelList = _ContactService.GetAdminContactModelListDB();
ViewBag.AdminContactModelList = adminContactModelList;
}
ViewBag.IsSamplingPlanner = IsSamplingPlanner;
if (IsSamplingPlanner)
{
ViewBag.ContactModel = contactModel;
if (contactModel.SamplingPlanner_ProvincesTVItemID.Contains(ProvinceTVItemID.ToString()))
{
SamplingPlanSubsectorModel SamplingPlanSubsectorModel = _SamplingPlanSubsectorService.GetSamplingPlanSubsectorModelWithSamplingPlanIDAndSubsectorTVItemIDDB(SamplingPlanID, SubsectorTVItemID);
if (string.IsNullOrWhiteSpace(SamplingPlanSubsectorModel.Error))
{
List <SamplingPlanSubsectorSiteModel> SamplingPlanSubsectorSiteModelList = _SamplingPlanSubsectorSiteService.GetSamplingPlanSubsectorSiteModelListWithSamplingPlanSubsectorIDDB(SamplingPlanSubsectorModel.SamplingPlanSubsectorID);
ViewBag.SamplingPlanSubsectorSiteModelList = SamplingPlanSubsectorSiteModelList;
}
List <TVItemModel> tvItemModelMWQMSiteList = _TVItemService.GetChildrenTVItemModelListWithTVItemIDAndTVTypeDB(SubsectorTVItemID, TVTypeEnum.MWQMSite);
ViewBag.TVItemModelMWQMSiteList = tvItemModelMWQMSiteList;
}
}
return(PartialView());
}
public SamplingPlanSubsectorModel PostUpdateSamplingPlanSubsectorDB(SamplingPlanSubsectorModel SamplingPlanSubsectorModel)
{
string retStr = SamplingPlanSubsectorModelOK(SamplingPlanSubsectorModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
SamplingPlanSubsector SamplingPlanSubsectorToUpdate = GetSamplingPlanSubsectorWithSamplingPlanSubsectorIDDB(SamplingPlanSubsectorModel.SamplingPlanSubsectorID);
if (SamplingPlanSubsectorToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.SamplingPlanSubsector)));
}
retStr = FillSamplingPlanSubsector(SamplingPlanSubsectorToUpdate, SamplingPlanSubsectorModel, 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("SamplingPlanSubsectors", SamplingPlanSubsectorToUpdate.SamplingPlanSubsectorID, LogCommandEnum.Change, SamplingPlanSubsectorToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetSamplingPlanSubsectorModelWithSamplingPlanSubsectorIDDB(SamplingPlanSubsectorToUpdate.SamplingPlanSubsectorID));
}
// Check
public string SamplingPlanSubsectorModelOK(SamplingPlanSubsectorModel samplingPlanSubsectorModel)
{
string retStr = FieldCheckNotZeroInt(samplingPlanSubsectorModel.SamplingPlanID, ServiceRes.SamplingPlanID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotZeroInt(samplingPlanSubsectorModel.SubsectorTVItemID, ServiceRes.SubsectorTVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(samplingPlanSubsectorModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
// Fill
public string FillSamplingPlanSubsector(SamplingPlanSubsector samplingPlanSubsector, SamplingPlanSubsectorModel samplingPlanSubsectorModel, ContactOK contactOK)
{
samplingPlanSubsector.DBCommand = (int)samplingPlanSubsectorModel.DBCommand;
samplingPlanSubsector.SamplingPlanID = samplingPlanSubsectorModel.SamplingPlanID;
samplingPlanSubsector.SubsectorTVItemID = samplingPlanSubsectorModel.SubsectorTVItemID;
samplingPlanSubsector.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
samplingPlanSubsector.LastUpdateContactTVItemID = 2;
}
else
{
samplingPlanSubsector.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}