public ActionResult NewCityMaintenance(CityMaintenanceModel m) { bool success = true; WebView.WebService._base myWebService; myWebService = new WebService._base(); bool selected = false; WebService._base.CityMaintenance newCityMain = new WebService._base.CityMaintenance(); //System.Diagnostics.Debug.WriteLine("City NAME : " + m.City_Name + " State ID : " + m.State_CODE); string SCode = m.State_CODE; //System.Diagnostics.Debug.WriteLine("Success1 :: " + SCode); char s = (':'); string[] p = SCode.Split(s); //System.Diagnostics.Debug.WriteLine("Success :: " + p[0]); //System.Diagnostics.Debug.WriteLine("Success :: " + p[1]); newCityMain.STATE_CODE = p[0]; newCityMain.CITY_NAME = m.City_Name; newCityMain.DESCRIPTION_STATE = p[1]; success = myWebService.AddCityMaintenance(newCityMain); selected = true; //System.Diagnostics.Debug.WriteLine("Success :: " + success); //System.Diagnostics.Debug.WriteLine("ModelState :: " + ModelState.IsValid); //System.Diagnostics.Debug.WriteLine("selected :: " + selected); if (ModelState.IsValid && selected) { if (success == true) { System.Diagnostics.Debug.WriteLine("pizal 1"); return(RedirectToAction("NewSave")); } else { System.Diagnostics.Debug.WriteLine("pizal 1"); return(RedirectToAction("NewSaveFail")); // store to db failed. } } List <SelectListItem> listStateID = new List <SelectListItem>(); using (Entities ctxData = new Entities()) { listStateID.Add(new SelectListItem() { Text = "", Value = "" }); var queryState = (from q in ctxData.WV_STATE_MAST orderby q.STATE_ID descending select new { q.STATE_ID, q.STATE_NAME }); foreach (var a in queryState.Distinct()) { listStateID.Add(new SelectListItem() { Text = a.STATE_NAME, Value = a.STATE_ID }); } ViewBag.StateID = listStateID; } return(View(m)); }