public SamplingPlanEmailModel GetSamplingPlanEmailModelWithSamplingPlanEmailIDDB(int SamplingPlanEmailID)
{
SamplingPlanEmailModel SamplingPlanEmailModel = (from c in db.SamplingPlanEmails
let samplingPlanName = (from p in db.SamplingPlans where c.SamplingPlanID == p.SamplingPlanID select p.SamplingPlanName).FirstOrDefault()
where c.SamplingPlanEmailID == SamplingPlanEmailID
select new SamplingPlanEmailModel
{
Error = "",
SamplingPlanEmailID = c.SamplingPlanEmailID,
DBCommand = (DBCommandEnum)c.DBCommand,
Email = c.Email,
IsContractor = c.IsContractor,
LabSheetHasValueOver500 = c.LabSheetHasValueOver500,
LabSheetReceived = c.LabSheetReceived,
LabSheetAccepted = c.LabSheetAccepted,
LabSheetRejected = c.LabSheetRejected,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <SamplingPlanEmailModel>();
if (SamplingPlanEmailModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_,
ServiceRes.SamplingPlanEmail,
ServiceRes.SamplingPlanEmailID,
SamplingPlanEmailID.ToString())));
}
return(SamplingPlanEmailModel);
}
public SamplingPlanEmailModel PostAddSamplingPlanEmailDB(SamplingPlanEmailModel SamplingPlanEmailModel)
{
string retStr = SamplingPlanEmailModelOK(SamplingPlanEmailModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
SamplingPlanEmailModel SamplingPlanEmailModelExist = GetSamplingPlanEmailModelExistDB(SamplingPlanEmailModel);
if (string.IsNullOrWhiteSpace(SamplingPlanEmailModelExist.Error))
{
return(ReturnError(string.Format(ServiceRes._AlreadyExists, ServiceRes.SamplingPlanEmail)));
}
SamplingPlanEmail SamplingPlanEmailNew = new SamplingPlanEmail();
retStr = FillSamplingPlanEmail(SamplingPlanEmailNew, SamplingPlanEmailModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.SamplingPlanEmails.Add(SamplingPlanEmailNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("SamplingPlanEmails", SamplingPlanEmailNew.SamplingPlanEmailID, LogCommandEnum.Add, SamplingPlanEmailNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetSamplingPlanEmailModelWithSamplingPlanEmailIDDB(SamplingPlanEmailNew.SamplingPlanEmailID));
}
public SamplingPlanEmailModel PostUpdateSamplingPlanEmailDB(SamplingPlanEmailModel SamplingPlanEmailModel)
{
string retStr = SamplingPlanEmailModelOK(SamplingPlanEmailModel);
if (!string.IsNullOrEmpty(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
SamplingPlanEmail SamplingPlanEmailToUpdate = GetSamplingPlanEmailWithSamplingPlanEmailIDDB(SamplingPlanEmailModel.SamplingPlanEmailID);
if (SamplingPlanEmailToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.SamplingPlanEmail)));
}
retStr = FillSamplingPlanEmail(SamplingPlanEmailToUpdate, SamplingPlanEmailModel, 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("SamplingPlanEmails", SamplingPlanEmailToUpdate.SamplingPlanEmailID, LogCommandEnum.Change, SamplingPlanEmailToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetSamplingPlanEmailModelWithSamplingPlanEmailIDDB(SamplingPlanEmailToUpdate.SamplingPlanEmailID));
}
// Fill
public string FillSamplingPlanEmail(SamplingPlanEmail SamplingPlanEmail, SamplingPlanEmailModel SamplingPlanEmailModel, ContactOK contactOK)
{
SamplingPlanEmail.DBCommand = (int)SamplingPlanEmailModel.DBCommand;
SamplingPlanEmail.SamplingPlanID = SamplingPlanEmailModel.SamplingPlanID;
SamplingPlanEmail.Email = SamplingPlanEmailModel.Email;
SamplingPlanEmail.IsContractor = SamplingPlanEmailModel.IsContractor;
SamplingPlanEmail.LabSheetHasValueOver500 = SamplingPlanEmailModel.LabSheetHasValueOver500;
SamplingPlanEmail.LabSheetReceived = SamplingPlanEmailModel.LabSheetReceived;
SamplingPlanEmail.LabSheetAccepted = SamplingPlanEmailModel.LabSheetAccepted;
SamplingPlanEmail.LabSheetRejected = SamplingPlanEmailModel.LabSheetRejected;
SamplingPlanEmail.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
SamplingPlanEmail.LastUpdateContactTVItemID = 2;
}
else
{
SamplingPlanEmail.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
// Check
public string SamplingPlanEmailModelOK(SamplingPlanEmailModel samplingPlanEmailModel)
{
string retStr = FieldCheckIfNotNullNotZeroInt(samplingPlanEmailModel.SamplingPlanID, ServiceRes.SamplingPlanID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndMinMaxLengthString(samplingPlanEmailModel.Email, ServiceRes.Email, 3, 150);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(samplingPlanEmailModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public JsonResult SamplingPlanEmailDeleteJSON(int SamplingPlanEmailID)
{
SamplingPlanEmailModel SamplingPlanEmailModel = _SamplingPlanEmailService.PostDeleteSamplingPlanEmailDB(SamplingPlanEmailID);
return(Json(SamplingPlanEmailModel.Error, JsonRequestBehavior.AllowGet));
}
public JsonResult SamplingPlanEmailAddOrModifyJSON(FormCollection fc)
{
SamplingPlanEmailModel SamplingPlanEmailModel = _SamplingPlanEmailService.SamplingPlanEmailAddOrModifyDB(fc);
return(Json(SamplingPlanEmailModel.Error, JsonRequestBehavior.AllowGet));
}
// Post
public SamplingPlanEmailModel SamplingPlanEmailAddOrModifyDB(FormCollection fc)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrWhiteSpace(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
int SamplingPlanEmailID = 0;
int SamplingPlanID = 0;
string Email = "";
bool IsContractor = false;
bool LabSheetHasValueOver500 = false;
bool LabSheetReceived = false;
bool LabSheetAccepted = false;
bool LabSheetRejected = false;
int.TryParse(fc["SamplingPlanEmailID"], out SamplingPlanEmailID);
// if 0 then want to add new SamplingPlanEmail else want to modify
int.TryParse(fc["SamplingPlanID"], out SamplingPlanID);
if (SamplingPlanID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.SamplingPlanID)));
}
Email = fc["Email"];
if (string.IsNullOrWhiteSpace(Email))
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.Email)));
}
if (!string.IsNullOrWhiteSpace(fc["IsContractor"]))
{
if (bool.Parse(fc["IsContractor"]))
{
IsContractor = true;
}
}
if (!string.IsNullOrWhiteSpace(fc["LabSheetHasValueOver500"]))
{
if (bool.Parse(fc["LabSheetHasValueOver500"]))
{
LabSheetHasValueOver500 = true;
}
}
if (!string.IsNullOrWhiteSpace(fc["LabSheetReceived"]))
{
if (bool.Parse(fc["LabSheetReceived"]))
{
LabSheetReceived = true;
}
}
if (!string.IsNullOrWhiteSpace(fc["LabSheetAccepted"]))
{
if (bool.Parse(fc["LabSheetAccepted"]))
{
LabSheetAccepted = true;
}
}
if (!string.IsNullOrWhiteSpace(fc["LabSheetRejected"]))
{
if (bool.Parse(fc["LabSheetRejected"]))
{
LabSheetRejected = true;
}
}
SamplingPlanEmailModel SamplingPlanEmailModelRet = new SamplingPlanEmailModel();
using (TransactionScope ts = new TransactionScope())
{
if (SamplingPlanEmailID == 0)
{
SamplingPlanEmailModel SamplingPlanEmailModelNew = new SamplingPlanEmailModel()
{
DBCommand = DBCommandEnum.Original,
SamplingPlanID = SamplingPlanID,
Email = Email,
IsContractor = IsContractor,
LabSheetHasValueOver500 = LabSheetHasValueOver500,
LabSheetReceived = LabSheetReceived,
LabSheetAccepted = LabSheetAccepted,
LabSheetRejected = LabSheetRejected,
};
SamplingPlanEmailModelRet = PostAddSamplingPlanEmailDB(SamplingPlanEmailModelNew);
if (!string.IsNullOrWhiteSpace(SamplingPlanEmailModelRet.Error))
{
ReturnError(SamplingPlanEmailModelRet.Error);
}
}
else
{
SamplingPlanEmailModel SamplingPlanEmailModelToUpdate = GetSamplingPlanEmailModelWithSamplingPlanEmailIDDB(SamplingPlanEmailID);
SamplingPlanEmailModelToUpdate.DBCommand = DBCommandEnum.Original;
SamplingPlanEmailModelToUpdate.SamplingPlanID = SamplingPlanID;
SamplingPlanEmailModelToUpdate.Email = Email;
SamplingPlanEmailModelToUpdate.IsContractor = IsContractor;
SamplingPlanEmailModelToUpdate.LabSheetHasValueOver500 = LabSheetHasValueOver500;
SamplingPlanEmailModelToUpdate.LabSheetReceived = LabSheetReceived;
SamplingPlanEmailModelToUpdate.LabSheetAccepted = LabSheetAccepted;
SamplingPlanEmailModelToUpdate.LabSheetRejected = LabSheetRejected;
SamplingPlanEmailModelRet = PostUpdateSamplingPlanEmailDB(SamplingPlanEmailModelToUpdate);
if (!string.IsNullOrWhiteSpace(SamplingPlanEmailModelRet.Error))
{
ReturnError(SamplingPlanEmailModelRet.Error);
}
}
ts.Complete();
}
return(SamplingPlanEmailModelRet);
}