public async Task <ActionResult> Create()
{
var wildcardmodel = new WildCardModel();
wildcardmodel.ActionTypeList = new SelectList(await CommonModel.GetActionTypes(), "Value", "Text");
if (CurrentUser.UserTypeName.ToLower() == "super admin")
{
wildcardmodel.IsAdmin = true;
wildcardmodel.CompanyList = new SelectList(await CommonModel.GetCompanies(), "Name", "Text");
}
return(View(wildcardmodel));
}
public async Task <ActionResult> Create(WildCardModel wildcardModel)
{
wildcardModel.UserId = CurrentUser.UserId;
if (CurrentUser.UserTypeName.ToLower() != "super admin")
{
wildcardModel.CompanyId = CurrentUser.CompanyId;
}
var response = await _wildCardRepo.AddUpdateDeleteWildCards(wildcardModel, 'I');
_wildCardRepo.Save();
TempData["response"] = response;
return(RedirectToAction("Index"));
}
public async Task <ResponseModel> AddUpdateDeleteWildCards(WildCardModel wildCardModel, char action)
{
var actionTypeIds = "";
foreach (var item in wildCardModel.actionTypes)
{
actionTypeIds = actionTypeIds + "," + item;
}
actionTypeIds = actionTypeIds.TrimStart(',');
actionTypeIds = actionTypeIds.TrimEnd(',');
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@WildCardId", wildCardModel.WildCardId);
sp.Add(param);
param = new SqlParameter("@WildCard", (object)wildCardModel.WildCard);
sp.Add(param);
param = new SqlParameter("@IsActive", (object)wildCardModel.IsActive);
sp.Add(param);
param = new SqlParameter("@ACTION", (object)action);
sp.Add(param);
param = new SqlParameter("@USER", (object)wildCardModel.UserId);
sp.Add(param);
param = new SqlParameter("@ActionTypeIds", (object)actionTypeIds);
sp.Add(param);
param = new SqlParameter("@compId", ToDBNull(wildCardModel.CompanyId));
sp.Add(param);
var sql = "USPInsertUpdateDeleteWildCards @WildCardId,@WildCard,@IsActive,@ACTION,@USER,@ActionTypeIds,@compId";
var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).FirstOrDefaultAsync();
if (res.ResponseCode == 0)
{
res.IsSuccess = true;
}
return(res);
}
