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)); }