// Fill
public string FillUseOfSite(UseOfSite useOfSite, UseOfSiteModel useOfSiteModel, ContactOK contactOK)
{
useOfSite.DBCommand = (int)useOfSiteModel.DBCommand;
useOfSite.SiteTVItemID = useOfSiteModel.SiteTVItemID;
useOfSite.SubsectorTVItemID = useOfSiteModel.SubsectorTVItemID;
useOfSite.TVType = (int)useOfSiteModel.TVType;
useOfSite.Ordinal = useOfSiteModel.Ordinal;
useOfSite.StartYear = useOfSiteModel.StartYear;
useOfSite.EndYear = useOfSiteModel.EndYear;
useOfSite.UseWeight = useOfSiteModel.UseWeight;
useOfSite.Weight_perc = useOfSiteModel.Weight_perc;
useOfSite.UseEquation = useOfSiteModel.UseEquation;
useOfSite.Param1 = useOfSiteModel.Param1;
useOfSite.Param2 = useOfSiteModel.Param2;
useOfSite.Param3 = useOfSiteModel.Param3;
useOfSite.Param4 = useOfSiteModel.Param4;
useOfSite.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
useOfSite.LastUpdateContactTVItemID = 2;
}
else
{
useOfSite.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
public UseOfSiteModel GetUseOfSiteModelExist(UseOfSiteModel useOfSiteModel)
{
UseOfSiteModel useOfSiteModelRet = (from c in db.UseOfSites
let siteTVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.SiteTVItemID select cl.TVText).FirstOrDefault <string>()
let subsectorTVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.SubsectorTVItemID select cl.TVText).FirstOrDefault <string>()
where c.SubsectorTVItemID == useOfSiteModel.SubsectorTVItemID &&
c.TVType == (int)useOfSiteModel.TVType &&
c.SiteTVItemID == useOfSiteModel.SiteTVItemID &&
c.StartYear >= useOfSiteModel.StartYear &&
c.EndYear <= useOfSiteModel.EndYear
orderby c.UseOfSiteID descending
select new UseOfSiteModel
{
Error = "",
UseOfSiteID = c.UseOfSiteID,
DBCommand = (DBCommandEnum)c.DBCommand,
SiteTVItemID = c.SiteTVItemID,
SiteTVText = siteTVText,
SubsectorTVItemID = c.SubsectorTVItemID,
SubsectorTVText = subsectorTVText,
TVType = (TVTypeEnum)c.TVType,
Ordinal = c.Ordinal,
StartYear = c.StartYear,
EndYear = c.EndYear,
UseWeight = c.UseWeight,
Weight_perc = c.Weight_perc,
UseEquation = c.UseEquation,
Param1 = c.Param1,
Param2 = c.Param2,
Param3 = c.Param3,
Param4 = c.Param4,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <UseOfSiteModel>();
if (useOfSiteModelRet == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_,
ServiceRes.UseOfSite,
ServiceRes.SubsectorTVItemID + "," +
ServiceRes.TVType + "," +
ServiceRes.SiteTVItemID + "," +
ServiceRes.StartYear + "," +
ServiceRes.EndYear,
useOfSiteModel.SubsectorTVItemID.ToString() + "," +
useOfSiteModel.TVType.ToString() + "," +
useOfSiteModel.SiteTVItemID.ToString() + "," +
useOfSiteModel.StartYear + "," +
useOfSiteModel.EndYear
)));
}
return(useOfSiteModelRet);
}
// Post
public UseOfSiteModel PostAddUseOfSiteDB(UseOfSiteModel useOfSiteModel)
{
string retStr = UseOfSiteModelOK(useOfSiteModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
UseOfSiteModel useOfSiteModelExist = GetUseOfSiteModelExist(useOfSiteModel);
if (string.IsNullOrWhiteSpace(useOfSiteModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.UseOfSite)));
}
UseOfSite useOfSiteNew = new UseOfSite();
retStr = FillUseOfSite(useOfSiteNew, useOfSiteModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.UseOfSites.Add(useOfSiteNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("UseOfSites", useOfSiteNew.UseOfSiteID, LogCommandEnum.Add, useOfSiteNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetUseOfSiteModelWithUseOfSiteIDDB(useOfSiteNew.UseOfSiteID));
}
public UseOfSiteModel PostUpdateUseOfSiteDB(UseOfSiteModel useOfSiteModel)
{
string retStr = UseOfSiteModelOK(useOfSiteModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
UseOfSite useOfSiteToUpdate = GetUseOfSiteWithUseOfSiteIDDB(useOfSiteModel.UseOfSiteID);
if (useOfSiteToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.UseOfSite)));
}
retStr = FillUseOfSite(useOfSiteToUpdate, useOfSiteModel, 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("UseOfSites", useOfSiteToUpdate.UseOfSiteID, LogCommandEnum.Change, useOfSiteToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetUseOfSiteModelWithUseOfSiteIDDB(useOfSiteToUpdate.UseOfSiteID));
}
public UseOfSiteModel GetUseOfSiteModelWithUseOfSiteIDDB(int UseOfSiteID)
{
UseOfSiteModel UseOfSiteModel = (from c in db.UseOfSites
let siteTVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.SiteTVItemID select cl.TVText).FirstOrDefault <string>()
let subsectorTVText = (from cl in db.TVItemLanguages where cl.Language == (int)LanguageRequest && cl.TVItemID == c.SubsectorTVItemID select cl.TVText).FirstOrDefault <string>()
where c.UseOfSiteID == UseOfSiteID
select new UseOfSiteModel
{
Error = "",
UseOfSiteID = c.UseOfSiteID,
DBCommand = (DBCommandEnum)c.DBCommand,
SiteTVItemID = c.SiteTVItemID,
SiteTVText = siteTVText,
SubsectorTVItemID = c.SubsectorTVItemID,
SubsectorTVText = subsectorTVText,
TVType = (TVTypeEnum)c.TVType,
Ordinal = c.Ordinal,
StartYear = c.StartYear,
EndYear = c.EndYear,
UseWeight = c.UseWeight,
Weight_perc = c.Weight_perc,
UseEquation = c.UseEquation,
Param1 = c.Param1,
Param2 = c.Param2,
Param3 = c.Param3,
Param4 = c.Param4,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <UseOfSiteModel>();
if (UseOfSiteModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.UseOfSite, ServiceRes.UseOfSiteID, UseOfSiteID)));
}
return(UseOfSiteModel);
}
// Check
public string UseOfSiteModelOK(UseOfSiteModel useOfSiteModel)
{
string retStr = FieldCheckNotZeroInt(useOfSiteModel.SiteTVItemID, ServiceRes.SiteTVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotZeroInt(useOfSiteModel.SubsectorTVItemID, ServiceRes.SubsectorTVItemID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.TVTypeOK(useOfSiteModel.TVType);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndWithinRangeInt(useOfSiteModel.Ordinal, ServiceRes.Ordinal, 0, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotZeroInt(useOfSiteModel.StartYear, ServiceRes.StartYear);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotZeroInt(useOfSiteModel.EndYear, ServiceRes.EndYear);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
if (useOfSiteModel.StartYear > useOfSiteModel.EndYear)
{
return(string.Format(ServiceRes._IsLaterThan_, ServiceRes.StartYear, ServiceRes.EndYear));
}
//retStr = FieldCheckNotNullBool(useOfSiteModel.UseWeight, ServiceRes.UseWeight);
//if (!string.IsNullOrWhiteSpace(retStr))
//{
// return retStr;
//}
//retStr = FieldCheckNotNullAndWithinRangeDouble(useOfSiteModel.Weight_perc, ServiceRes.Weight_perc, 0, 100);
//if (!string.IsNullOrWhiteSpace(retStr))
//{
// return retStr;
//}
retStr = FieldCheckIfNotNullWithinRangeDouble(useOfSiteModel.Weight_perc, ServiceRes.Weight_perc, 0, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
//retStr = FieldCheckNotNullBool(useOfSiteModel.UseEquation, ServiceRes.UseEquation);
//if (!string.IsNullOrWhiteSpace(retStr))
//{
// return retStr;
//}
retStr = FieldCheckIfNotNullWithinRangeDouble(useOfSiteModel.Param1, ServiceRes.Param1, 0, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(useOfSiteModel.Param2, ServiceRes.Param2, 0, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(useOfSiteModel.Param3, ServiceRes.Param3, 0, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckIfNotNullWithinRangeDouble(useOfSiteModel.Param4, ServiceRes.Param4, 0, 100);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(useOfSiteModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
