public ActionResult UpdateData(string CityIdVal, string txtCity, string txtStateID, string txtSName)
{
bool success = true;
System.Diagnostics.Debug.WriteLine("pizal");
WebView.WebService._base myWebService;
myWebService = new WebService._base();
WebService._base.CityMaintenance newCityMain = new WebService._base.CityMaintenance();
newCityMain.STATE_CODE = txtStateID;
newCityMain.CITY_NAME = txtCity;
newCityMain.DESCRIPTION_STATE = txtSName;
success = myWebService.UpdateCityMaintenance(newCityMain, CityIdVal);
System.Diagnostics.Debug.WriteLine("pizal" + success);
return(Json(new
{
Success = success
}, JsonRequestBehavior.AllowGet));
}
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));
}
