public SiteCampaignLobFormulaViewModel Create(SiteCampaignLobFormulaViewModel model)
{
//check if exists
var origData = this.Get(model.SiteID, model.CampaignID, model.LoBID, null, true);
if (origData.Count() > 0)
{
throw new ArgumentException("Insert failed. Mapping already exists.");
}
var data = new SiteCampaignLobFormula()
{
SiteID = model.SiteID,
CampaignID = model.CampaignID,
LoBID = model.LoBID,
DynamicFormulaID = model.DynamicFormulaID,
DateCreated = DateTime.Now,
DateModified = null,
Active = true
};
_context.Add <SiteCampaignLobFormula>(data);
_context.SaveChanges();
model.ID = data.ID;
return(model);
}
public ActionResult Save(DynamicFormulaView data)
{
string username = User.Identity.GetUserName();
CommonView model = new CommonView();
string message = string.Empty;
try
{
var sclf = new SiteCampaignLobFormulaViewModel()
{
ID = data.ID,
SiteID = data.SiteID,
CampaignID = data.CampaignID,
LoBID = data.LobID,
DynamicFormulaID = data.FormulaID,
Active = true
};
if (data.ID == 0)
{
_siteCampaignLobFormulaService.Create(sclf);
if (sclf.ID > 0)
{
message = "Data added.";
data.ID = sclf.ID;
}
}
else
{
//update
_siteCampaignLobFormulaService.Update(sclf);
message = "Data updated.";
}
model.Message = message;
}
catch (Exception ex)
{
if (ex.GetType() == typeof(ArgumentException))
{
model.Message = ((ArgumentException)ex).Message;
}
else
{
model.Message = "Unable to save data. Please contact your system administrator.";
}
}
return(Json(model, JsonRequestBehavior.AllowGet));
}
public void Save(ref SiteCampaignLobFormulaViewModel model)
{
var data = _context.Add <SiteCampaignLobFormula>(new SiteCampaignLobFormula()
{
SiteID = model.SiteID,
CampaignID = model.CampaignID,
LoBID = model.LoBID,
DynamicFormulaID = model.DynamicFormulaID,
DateCreated = model.DateCreated,
Active = model.Active
});
_context.SaveChanges();
model.ID = data.ID;
}
public SiteCampaignLobFormulaViewModel Update(SiteCampaignLobFormulaViewModel model)
{
//check if exists
#region Validate
var data = _context.AsQueryable <SiteCampaignLobFormula>()
.Where(x => x.ID == model.ID).FirstOrDefault();
long origSiteID = 0;
long origCampaignID = 0;
long origLobID = 0;
if (data != null)
{
if (data.ID > 0)
{
origSiteID = data.SiteID;
origCampaignID = data.CampaignID;
origLobID = data.LoBID;
}
}
if (origSiteID != model.SiteID && origCampaignID != model.CampaignID && origLobID != model.LoBID)
{
var existingdata = this.Get(model.SiteID, model.CampaignID, model.LoBID, null, true);
if (existingdata.Count() > 0)
{
throw new ArgumentException("Update failed. Mapping already exists.");
}
}
#endregion Validate
data.SiteID = model.SiteID;
data.CampaignID = model.CampaignID;
data.LoBID = model.LoBID;
data.DynamicFormulaID = model.DynamicFormulaID;
data.DateModified = DateTime.Now;
_context.Update <SiteCampaignLobFormula>(data);
_context.SaveChanges();
return(model);
}
