public async Task <ResponseModel> AddUpdateDeleteEmailHeaderFooter(EmailHeaderFooterModel emailHeaderFooterModel, char action)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@EmailHeaderFooterId", ToDBNull(emailHeaderFooterModel.EmailHeaderFooterId));
sp.Add(param);
param = new SqlParameter("@ActionTypeId", ToDBNull(emailHeaderFooterModel.ActionTypeId));
sp.Add(param);
param = new SqlParameter("@Name", (object)emailHeaderFooterModel.Name);
sp.Add(param);
param = new SqlParameter("@HeaderHTML", ToDBNull(emailHeaderFooterModel.HeaderHTML));
sp.Add(param);
param = new SqlParameter("@FooterHTML", ToDBNull(emailHeaderFooterModel.FooterHTML));
sp.Add(param);
param = new SqlParameter("@User", (object)emailHeaderFooterModel.UserId);
sp.Add(param);
param = new SqlParameter("@ISACTIVE", (object)emailHeaderFooterModel.IsActive);
sp.Add(param);
param = new SqlParameter("@Action", (object)action);
sp.Add(param);
param = new SqlParameter("@CompId", ToDBNull(emailHeaderFooterModel.CompanyId));
sp.Add(param);
var sql = "USPEmailHeaderFooterADDUPDATE @EmailHeaderFooterId,@ActionTypeId,@Name,@HeaderHTML,@FooterHTML,@User,@ISACTIVE,@Action,@CompId";
var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).FirstOrDefaultAsync();
if (res.ResponseCode == 0)
{
res.IsSuccess = true;
}
return(res);
}
public async Task <ActionResult> Create(EmailHeaderFooterModel emailheaderfooter)
{
if (ModelState.IsValid)
{
var emailheaderfooterModel = new EmailHeaderFooterModel
{
EmailHeaderFooterId = emailheaderfooter.EmailHeaderFooterId,
ActionTypeId = emailheaderfooter.ActionTypeId,
Name = emailheaderfooter.Name,
IsActive = emailheaderfooter.IsActive,
HeaderHTML = emailheaderfooter.HeaderHTML,
FooterHTML = emailheaderfooter.FooterHTML,
UserId = CurrentUser.UserId,
CompanyId = emailheaderfooter.CompanyId
};
if (CurrentUser.UserTypeName.ToLower() != "super admin")
{
emailheaderfooterModel.CompanyId = CurrentUser.CompanyId;
}
ResponseModel response = new ResponseModel();
if (emailheaderfooterModel.EmailHeaderFooterId != 0)
{
response = await _emailHeaderFooterRepo.AddUpdateDeleteEmailHeaderFooter(emailheaderfooterModel, 'U');
}
else
{
response = await _emailHeaderFooterRepo.AddUpdateDeleteEmailHeaderFooter(emailheaderfooterModel, 'I');
}
_emailHeaderFooterRepo.Save();
TempData["response"] = response;
return(RedirectToAction("Index"));
}
else
{
return(View(emailheaderfooter));
}
}
public async Task <ActionResult> Create()
{
var emailheaderfootermodel = new EmailHeaderFooterModel();
return(View(emailheaderfootermodel));
}
