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