public string UpdateState(StateVM state) { string stateId = string.Empty; SqlParameter[] parameters = { new SqlParameter { ParameterName = "@Id", Value = state.Id }, new SqlParameter { ParameterName = "@CountryId", Value = state.CountryId }, new SqlParameter { ParameterName = "@Code", Value = state.Code }, new SqlParameter { ParameterName = "@Name", Value = state.Name }, new SqlParameter { ParameterName = "@IsActive", Value = state.IsActive }, new SqlParameter { ParameterName = "@UpdatedBy", Value = state.UpdatedBy } }; stateId = Convert.ToString(DALHelper.ExecuteScalar("UpdateState", parameters)); return(stateId); }
public ActionResult Select() { string mode = Request.QueryString["Grid-mode"]; if (!string.IsNullOrEmpty(mode)) { return(this.RedirectToAction("Create")); } else { List <StateVM> viewModels = new List <StateVM>(); StateBAL balObject = new StateBAL(); IQueryable <Entities.State> entites = balObject.GetAll(); CountryBAL countryBAL = new CountryBAL(); IQueryable <Entities.Country> countries = countryBAL.GetAll(); foreach (Entities.State entity in entites) { StateVM viewModel = new StateVM(); viewModel.StateId = entity.StateId; viewModel.StateName = entity.StateName; viewModel.CountryName = countries.Where(c => c.CountryId == entity.CountryId).FirstOrDefault().CountryName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(View(new GridModel <StateVM> { Data = viewModels })); } }
public IActionResult State(StateVM stateVM, string selectedCountryId, string selectedStateId) { StateVM_DataManager stateVM_DataManager = new StateVM_DataManager(); stateVM_DataManager.SaveState(stateVM); return(RedirectToAction("State", stateVM)); }
public ActionResult AddState(StateVM stateVM) { stateVM.ValidStates = StatesList.States; stateVM.State = (stateVM.State ?? new State { StateAbbreviation = "", StateName = null }); if (ModelState.IsValid) { try { stateVM.State.StateName = StatesList.States.FirstOrDefault(s => stateVM?.State.StateAbbreviation == s.Value)?.Text; } catch (NullReferenceException) { stateVM.State.StateName = null; } if (stateVM.State.StateName == null) { return(View(stateVM)); } StateRepository.Add(stateVM.State); return(RedirectToAction("States")); } return(View(stateVM)); }
public ActionResult AddState2(StateVM sVM) { IEnumerable <State> states = StateRepository.GetAll(); IEnumerable <State> allStates = StateRepository.AllStates(); if (states.Any(s => s.StateAbbreviation == sVM.State.StateAbbreviation)) { ModelState.AddModelError("StateAbbreviation", "This State Abbreviation is already in use."); } if (!allStates.Any(s => s.StateAbbreviation == sVM.State.StateAbbreviation)) { ModelState.AddModelError("StateAbbreviation", "Please choose a valid state to add."); } foreach (var item in allStates) { if (item.StateAbbreviation == sVM.State.StateAbbreviation) { sVM.State = item; } } if (ModelState.IsValid) { StateRepository.Add(sVM.State); return(RedirectToAction("States")); } return(View("AddState2", sVM)); }
public ActionResult AddState() { StateVM model = new StateVM(); model.ValidStates = StatesList.States; model.State = new State(); return(View(model)); }
public ActionResult DeleteState(StateVM stateVM) { var state = new State(); state.StateAbbreviation = stateVM.StateAbbreviation; state.StateName = stateVM.StateName; StateRepository.Delete(state.StateAbbreviation); return(RedirectToAction("States")); }
public ActionResult DeleteState(string id) { var state = StateRepository.Get(id); var stateVM = new StateVM(); stateVM.StateAbbreviation = state.StateAbbreviation; stateVM.StateName = state.StateName; return(View(stateVM)); }
public ActionResult AddState2() { StateVM svm = new StateVM(); svm.SetStateItems(StateRepository.GetAll()); svm.SetAllStateItems(StateRepository.AllStates()); svm.SetAvailableStateItems(StateRepository.AvailableStates()); return(View(svm)); }
// // GET: /SysAdmin/State/Create public ActionResult Create() { StateVM viewModel = new StateVM(); //AcademicYearBAL academicYearBAL = new AcademicYearBAL(); //viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() }; //CountryBAL countryBAL = new CountryBAL(); //viewModel.Countries = from obj in countryBAL.GetAll() select new SelectListItem() { Text = obj.CountryName, Value = obj.CountryId.ToString() }; viewModel.Status = true; return(View(viewModel)); }
public StateVM EditState(StateVM c) { DB.tblState State = IMSDB.tblStates.Find(c.StateId); if (State != null) { State.StateName = c.StateName; State.CountryId = c.Country.CountryId; //State.StateCode = c.StateCode; State.IsActive = c.IsActive; IMSDB.Entry(State).State = EntityState.Modified; IMSDB.SaveChanges(); } return(c); }
public StateVM AddState(StateVM c) { DB.tblState State = IMSDB.tblStates.Add( new DB.tblState { //StateCode = c.StateCode, StateName = c.StateName, CountryId = c.Country.CountryId, IsActive = c.IsActive }); IMSDB.SaveChanges(); c.StateId = State.StateId; return(c); }
public ActionResult SaveSts(StateVM Sts) { List <SessionListnew> list = Session["SesDet"] as List <SessionListnew>; if (list == null) { return(Redirect("Login/InLogin")); } else { Sts.CmpyCode = list[0].CmpyCode; return(Json(_StService.SaveSts(Sts), JsonRequestBehavior.AllowGet)); } }
public ActionResult EditState(StateVM stateVM) { if (ModelState.IsValid) { var state = new State(); state.StateAbbreviation = stateVM.StateAbbreviation; state.StateName = stateVM.StateName; StateRepository.Edit(state); return(RedirectToAction("States")); } else { return(View("EditState", stateVM)); } }
public ActionResult Edit(int id) { var state = stateRepository.GetStateById(id); if (state != null && state.Count > 0) { StateVM model = new StateVM(); model = state[0]; var countryList = new SelectList(countryRepository.GetCountries(), "Id", "Name").ToList(); ViewBag.CountryList = countryList; return(View(model)); } return(RedirectToAction("List")); }
public async Task <ActionResult <StateVM> > GetState(int id) { StateVM p = new StateVM(); if (id > 0) { var state = await setupBL.GetStateByIDAsync(id); if (state != null) { p.Name = state.Name; p.Code = state.Code; p.CountryId = state.CountryId; } } return(p); }
// // GET: /SysAdmin/State/Details/5 public ActionResult Details(int id) { StateVM viewModel = new StateVM(); StateBAL balObject = new StateBAL(); IQueryable <Entities.State> entites = balObject.FindBy(a => a.StateId == id); if (entites != null && entites.Count() > 0) { Entities.State entity = entites.FirstOrDefault(); viewModel.StateId = entity.StateId; viewModel.StateName = entity.StateName; CountryBAL countryBAL = new CountryBAL(); viewModel.CountryName = countryBAL.FindBy(c => c.CountryId == entity.CountryId).FirstOrDefault().CountryName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; } return(View(viewModel)); }
public async Task <ActionResult <bool> > UpdateState(StateVM p) { bool result = false; if (ModelState.IsValid) { var state = await setupBL.GetStateByIDAsync(p.Code); if (state != null) { state.Name = p.Name; if (await setupBL.UpdateStateAsync(state)) { result = true; } } } return(result); }
public ActionResult Edit(StateVM viewModel) { try { // TODO: Add update logic here if (ModelState.IsValid) { Entities.State entity = new Entities.State(); entity.StateId = viewModel.StateId; entity.CountryId = viewModel.CountryId; entity.StateName = viewModel.StateName; entity.Status = viewModel.Status; entity.Remark = viewModel.Remark; StateBAL balObject = new StateBAL(); balObject.Edit(entity); return(RedirectToAction("Index")); } else { //AcademicYearBAL academicYearBAL = new AcademicYearBAL(); //viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() }; CountryBAL countryBAL = new CountryBAL(); viewModel.Countries = from obj in countryBAL.GetAll() select new SelectListItem() { Text = obj.CountryName, Value = obj.CountryId.ToString() }; return(View(viewModel)); } } catch { //AcademicYearBAL academicYearBAL = new AcademicYearBAL(); //viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() }; CountryBAL countryBAL = new CountryBAL(); viewModel.Countries = from obj in countryBAL.GetAll() select new SelectListItem() { Text = obj.CountryName, Value = obj.CountryId.ToString() }; return(View()); } }
public ActionResult Index() { List <StateVM> viewModels = new List <StateVM>(); StateBAL balObject = new StateBAL(); IQueryable <Entities.State> entites = balObject.GetAll(); foreach (Entities.State entity in entites) { StateVM viewModel = new StateVM(); viewModel.StateId = entity.StateId; viewModel.StateName = entity.StateName; viewModel.CountryName = entity.CountryName; viewModel.Status = entity.Status; viewModel.Remark = entity.Remark; viewModels.Add(viewModel); } return(View(new GridModel <StateVM> { Data = viewModels })); }
public ActionResult Edit(StateVM model) { try { string stateId = string.Empty; model.UpdatedBy = LogInManager.LoggedInUserId; stateId = stateRepository.UpdateState(model); if (!string.IsNullOrWhiteSpace(stateId)) { return(Json(new { IsSuccess = true, data = new { StateId = stateId } }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { IsSuccess = false, errorMessage = "State details not updated successfully." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { Utility.Utility.LogError(e, "Edit"); return(Json(new { IsSuccess = false, errorMessage = e.Message })); } }
public StateVM SaveSts(StateVM Sts) { try { if (!Sts.EditFlag) { var Drecord = new List <string>(); List <StateNew> ObjList = new List <StateNew>(); ObjList.AddRange(Sts.StateNew.Select(m => new StateNew { CmpyCode = m.CmpyCode, Code = m.Code, Name = m.Name, }).ToList()); int n = 0; n = ObjList.Count; while (n > 0) { int Bbs1 = _EzBusinessHelper.ExecuteScalar("Select count(*) as [count1] from MSM059 where CmpyCode='" + Sts.CmpyCode + "' and Code='" + ObjList[n - 1].Code + "'"); if (Bbs1 == 0) { StringBuilder sb = new StringBuilder(); sb.Append("'" + Sts.CmpyCode + "',"); sb.Append("'" + ObjList[n - 1].Code + "',"); sb.Append("'" + ObjList[n - 1].Name + "')"); using (TransactionScope scope = new TransactionScope()) { _EzBusinessHelper.ExecuteNonQuery("insert into MSM059(CmpyCode,Code,Name) values(" + sb.ToString() + ""); _EzBusinessHelper.ActivityLog(Sts.CmpyCode, Sts.UserName, "Add State Master", Sts.Code, Environment.MachineName); Sts.SaveFlag = true; Sts.ErrorMessage = string.Empty; scope.Complete(); } } else { Drecord.Add(ObjList[n - 1].Code.ToString()); Sts.Drecord = Drecord; Sts.SaveFlag = false; Sts.ErrorMessage = "Duplicate Record"; } n = n - 1; } //ds = _EzBusinessHelper.ExecuteDataSet("Select count(*) as [count1] from MSM059 where CmpyCode='" + Sts.CmpyCode + "' and Code='" + Sts.Code + "'"); //dt = ds.Tables[0]; //int Sts1 = 0; //foreach (DataRow dr in dt.Rows) //{ // Sts1 = int.Parse(dr["count1"].ToString()); //} //if (Sts1 == 0) //{ // StringBuilder sb = new StringBuilder(); // sb.Append("'" + Sts.CmpyCode + "',"); // //sb.Append("'UM',"); // sb.Append("'" + Sts.Code + "',"); // sb.Append("'" + Sts.Name + "')"); // _EzBusinessHelper.ExecuteNonQuery("insert into MSM059(CmpyCode,Code,Name) values(" + sb.ToString() + ""); // Sts.SaveFlag = true; // Sts.ErrorMessage = string.Empty; //} //else //{ // Sts.SaveFlag = false; // Sts.ErrorMessage = "Duplicate Record"; //} return(Sts); } var StsEdit = _EzBusinessHelper.ExecuteScalarDec("Select count(*) from MSM059 where CmpyCode='" + Sts.CmpyCode + "' and Code='" + Sts.Code + "'"); if (StsEdit != 0) { using (TransactionScope scope = new TransactionScope()) { _EzBusinessHelper.ExecuteNonQuery("update MSM059 set Name='" + Sts.Name + "' where CmpyCode='" + Sts.CmpyCode + "' and Code='" + Sts.Code + "'"); _EzBusinessHelper.ActivityLog(Sts.CmpyCode, Sts.UserName, "Update State Master", Sts.Code, Environment.MachineName); Sts.SaveFlag = true; Sts.ErrorMessage = string.Empty; scope.Complete(); } } else { Sts.SaveFlag = false; Sts.ErrorMessage = "Record not available"; } } catch (Exception ex) { Sts.SaveFlag = false; // unit.ErrorMessage = exceptionMessage; } return(Sts); }
public StateVM AddState(StateVM c) { return(_StateBL.AddState(c)); }
public int DeleteState(StateVM c) { return(_StateBL.DeleteState(c.StateId)); }
public StateVM EditState(StateVM c) { return(_StateBL.EditState(c)); }
public StateVM SaveSts(StateVM Sts) { return(_StRepo.SaveSts(Sts)); }