public async Task <ResponseModel> AddUpdateCountry(ManageCountryModel contry)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@cntyId", ToDBNull(contry.Cnty_Id));
sp.Add(param);
param = new SqlParameter("@CntyName", ToDBNull(contry.Cnty_Name));
sp.Add(param);
param = new SqlParameter("@Remarks", ToDBNull(contry.Remarks));
sp.Add(param);
param = new SqlParameter("@IsActive", (object)(contry.IsActive));
sp.Add(param);
param = new SqlParameter("@User", ToDBNull(contry.UserId));
sp.Add(param);
param = new SqlParameter("@Action", (object)contry.EventAction);
sp.Add(param);
var sql = "USPInsertUpdateCountry @cntyId,@CntyName,@Remarks,@IsActive,@User,@Action";
var res = await _context.Database.SqlQuery <ResponseModel>(sql, sp.ToArray()).SingleOrDefaultAsync();
if (res.ResponseCode == 0)
{
res.IsSuccess = true;
}
else
{
res.IsSuccess = false;
}
return(res);
}
public async Task <ActionResult> Edit(ManageCountryModel contry)
{
contry.EventAction = 'U';
contry.UserId = CurrentUser.UserId;
var response = await _Country.AddUpdateCountry(contry);
TempData["response"] = response;
return(RedirectToAction("Index"));
}
