public async Task <ResponseModel> AddUpdateState(ManageStateModel state)
{
List <SqlParameter> sp = new List <SqlParameter>();
SqlParameter param = new SqlParameter("@StateId", ToDBNull(state.St_ID));
sp.Add(param);
param = new SqlParameter("@StateName", ToDBNull(state.St_Name));
sp.Add(param);
param = new SqlParameter("@StateCode", ToDBNull(state.St_Code));
sp.Add(param);
param = new SqlParameter("@CntyID", ToDBNull(state.St_CntyID));
sp.Add(param);
param = new SqlParameter("@Remarks", ToDBNull(state.Remarks));
sp.Add(param);
param = new SqlParameter("@IsActive", (object)(state.IsActive));
sp.Add(param);
param = new SqlParameter("@User", ToDBNull(state.UserId));
sp.Add(param);
param = new SqlParameter("@Action", (object)state.EventAction);
sp.Add(param);
var sql = "USPInsertUpdateState @StateId,@StateName,@StateCode,@CntyID,@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(ManageStateModel state)
{
state.EventAction = 'U';
state.UserId = CurrentUser.UserId;
var response = await _State.AddUpdateState(state);
TempData["response"] = response;
return(RedirectToAction("Index"));
}
public async Task <ActionResult> Create()
{
ManageStateModel st = new ManageStateModel
{
_CountryList = new SelectList(dropdown.BindCountry(), "Value", "Text")
};
return(PartialView(st));
}
