public static ClsReturnValues setCity(ClsCity obj, Guid SessionID) { ClsReturnValues lst = new ClsReturnValues(); using (var db = new tdoEntities()) { lst = db.uspAddEditCity(obj.cityID, obj.cityName, obj.cityCode, obj.stateID, obj.createdByID, SessionID).FirstOrDefault(); } return lst; }
public JsonResult setCity(string cityID, string cityName, string cityCode, string stateID) { List<ClsUserDisplay> userDisplay = new List<ClsUserDisplay>(); using (tdoEntities db = new tdoEntities()) { userDisplay = db.uspGetUserDisplay(GetID()).ToList<ClsUserDisplay>(); } List<string> editableForms = Restriction.GetEditableForms(userDisplay); List<string> addableForms = Restriction.GetAddableForms(userDisplay); if (int.Parse(cityID) == 0 && !addableForms.Contains("City")) { return Json(new { id = 0, isSuccess = false, msg = "You are not allowed to add new records." }); } else if (int.Parse(cityID) != 0 && !editableForms.Contains("City")) { return Json(new { id = 0, isSuccess = false, msg = "You are not allowed to edit records." }); } if (cityID == "") { cityID = "0"; } Guid Session = new Guid(GetSession()); //do not hard code session ID and createdbyID int _id = 0; try { _id = int.Parse(cityID.Trim()); } catch { } ClsCity obj = new ClsCity() { cityID = _id, cityName = cityName, cityCode = cityCode, stateID = int.Parse(stateID), createdByID = GetID(), sessionID = Session }; ClsReturnValues k = Administration.setCity(obj, Session); return Json(new { id = k.ID, isSuccess = k.IsSuccess ?? false ? 1 : 0, msg = k.Response }); }