private bool Delete(int intPKID) { bool retval = false; objCountry = new tblCountry(); tblState ObjState = new tblState(); var _with1 = objCountry; if (_with1.LoadByPrimaryKey(intPKID)) { ObjState.Where.AppStateID.Value = intPKID; ObjState.Query.Load(); if (ObjState.RowCount > 0) { retval = false; } else { _with1.MarkAsDeleted(); _with1.Save(); retval = true; } } ObjState = null; objCountry = null; return(retval); }
public static State LoadStateByAbbreviation(string abb) { try { using (FoodOrderSystemEntities dc = new FoodOrderSystemEntities()) { tblState StateRow = dc.tblStates.FirstOrDefault(a => a.Abbreviation == abb); if (StateRow != null) { return(new State { Id = StateRow.Id, Abbreviation = StateRow.Abbreviation, Name = StateRow.Name }); } else { throw new Exception("Row not found..."); } } } catch (Exception ex) { throw ex; } }
public int Save(tblState tbl) { tbl.IsDelete = false; objData.tblStates.Add(tbl); objData.SaveChanges(); return(tbl.StateId.Value); }
private bool SaveData() { objCommon = new clsCommon(); if (objCommon.IsRecordExists("tblState", tblState.ColumnNames.AppState, tblState.ColumnNames.AppStateID, txtState.Text, hdnPKID.Value)) { DInfo.ShowMessage(" State already exits.", Enums.MessageType.Error); return(false); } objCommon = null; objState = new tblState(); if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objState.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value)); } else { objState.AddNew(); } objState.AppState = txtState.Text; objState.s_AppCountryID = ddlCountry.SelectedValue.ToString(); objState.Save(); iStateID = objState.AppStateID; objState = null; return(true); }
public IHttpActionResult PuttblState(int id, tblState tblState) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != tblState.Id) { return(BadRequest()); } db.Entry(tblState).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!tblStateExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
private bool Delete(int intPKID) { bool retval = false; objState = new tblState(); tblCity objCity = new tblCity(); if (objState.LoadByPrimaryKey(intPKID)) { objCity.Where.AppStateID.Value = intPKID; objCity.Query.Load(); if (objCity.RowCount > 0) { retval = false; } else { objState.MarkAsDeleted(); objState.Save(); retval = true; } } objCity = null; objState = null; return(retval); }
public ActionResult Update(tblState model) { var countries = objState.GetStates(); var test = countries.Where(p => p.StateName.ToUpper() == model.StateName.ToUpper() && p.CountryId == model.CountryId).FirstOrDefault(); StateDetails obj = new StateDetails(); if (test != null) { obj.Status = false; obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.AlreadyExist : "हि माहिती आधीपासून उपलब्ध आहे."; } else { obj.Status = true; obj.ErrorMessage = SettingsManager.Instance.Branding == "SINDHI" ? Resources.SPMOResources.UserinformationSaveFailed : "माहितीमध्ये बदल करण्यात आला आहे."; objState.Update(model); } int pageindex = 0; var filter = countries.OrderBy(p => p.StateId).Skip(pageindex * PageSize).Take(PageSize); Session["users"] = countries; Session["pageindex"] = 0; obj.StateList = filter; return(Json(obj, JsonRequestBehavior.AllowGet)); }
private void SetValuesToControls() { if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objPinCode = new tblPinCode(); if (objPinCode.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { txtPINCode.Text = objPinCode.AppPinCode.ToString(); chkIsActive.Checked = objPinCode.AppIsActive; tblCity objCity = new tblCity(); if (objCity.LoadByPrimaryKey(objPinCode.AppCityID)) { objCommon = new clsCommon(); tblState objState = new tblState(); if (objState.LoadByPrimaryKey(objCity.AppStateID)) { ddlCountry.SelectedValue = objState.s_AppCountryID; objCommon.FillDropDownList(ddlState, "tblState", tblState.ColumnNames.AppState, tblState.ColumnNames.AppStateID, "-- Select State --", tblState.ColumnNames.AppCountryID + "=" + ddlCountry.SelectedValue); ddlState.SelectedValue = objState.s_AppStateID; objCommon.FillDropDownList(ddlCity, "tblCity", tblCity.ColumnNames.AppCity, tblCity.ColumnNames.AppCityID, "-- Select City --", tblCity.ColumnNames.AppStateID + "=" + ddlState.SelectedValue); ddlCity.SelectedValue = objCity.s_AppCityID; } objState = null; objCommon = null; } objCity = null; } objPinCode = null; } }
public async Task <IActionResult> Edit(int id, [Bind("state_Id,country_Id,State")] tblState tblState) { if (id != tblState.state_Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(tblState); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!tblStateExists(tblState.state_Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["country_Id"] = new SelectList(_context.tblCountry, "country_Id", "country_Name", tblState.country_Id); return(View(tblState)); }
public string ChangeStatus(long id) { tblState user = _dbRepository.SelectById(id); user.IsActive = !user.IsActive; return(_dbRepository.Update(user)); }
public ActionResult GetStateList() { if (Session["AdminUser"] == null) { return(RedirectToAction("Login", "Home")); } List <tblState> stateList = new List <tblState>(); foreach (tblState state in db.tblStates.Include(c => c.tblCountry).ToList()) { tblState objState = new tblState(); objState.StateId = state.StateId; objState.StateName = state.StateName; objState.IsActive = state.IsActive; objState.CountryId = state.CountryId; objState.tblCountry = new tblCountry() { CountryId = state.CountryId, CountryName = state.tblCountry.CountryName }; stateList.Add(objState); } return(Json(stateList, JsonRequestBehavior.AllowGet)); }
public IHttpActionResult PuttblState(tblState tblState) { //if (!ModelState.IsValid) //{ // return BadRequest(ModelState); //} //if (id != tblState.ID) //{ // return BadRequest(); //} //db.Entry(tblState).State = EntityState.Modified; //try //{ // db.SaveChanges(); //} //catch (DbUpdateConcurrencyException) //{ // if (!tblStateExists(id)) // { // return NotFound(); // } // else // { // throw; // } //} //return StatusCode(HttpStatusCode.NoContent); if (tblState == null) { throw new ArgumentNullException("tblState"); } var data = db.tblStates.Where(w => w.ID == tblState.ID).Count();//.FirstOrDefault(); if (data >= 0) { tblState state = new tblState(); state.ID = tblState.ID; state.Name = tblState.Name; state.Created = System.DateTime.Now; state.CreatedBy = tblState.CreatedBy; state.Updated = System.DateTime.Now; state.UpdatedBy = tblState.UpdatedBy; state.Active = Convert.ToBoolean(tblState.Active); db.Entry(state).State = EntityState.Modified; db.SaveChanges(); return(Ok(new { code = 0, data = "State updated successfully." })); } else { return(Ok(new { code = 1, data = "State not found." })); } }
public ActionResult DeleteConfirmed(int id) { tblState tblState = db.tblStates.Find(id); db.tblStates.Remove(tblState); db.SaveChanges(); return(RedirectToAction("Index")); }
internal void Update(tblState model) { tblState newobj = objData.tblStates.Where(p => p.StateId == model.StateId && p.IsDelete == false).FirstOrDefault(); newobj.StateName = model.StateName; newobj.CountryId = model.CountryId; objData.SaveChanges(); }
public int DeleteStateDetails(string stateId) { tblState state = db.tblStates.Find(int.Parse(stateId)); db.tblStates.Remove(state); return(db.SaveChanges()); }
public int UpdateStateDetails(string stateId, string stateName, string countryId, string IsActive) { tblState state = db.tblStates.Find(int.Parse(stateId)); state.StateName = stateName; state.CountryId = int.Parse(countryId); state.IsActive = Convert.ToBoolean(IsActive); return(db.SaveChanges()); }
public ActionResult Edit(tblState model) { if (Session["AdminUser"] == null) { return(RedirectToAction("Login", "Home")); } db.Entry(model).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Details(int?id) { if (Session["AdminUser"] == null) { return(RedirectToAction("Login", "Home")); } tblState model = db.tblStates.Find(id); return(View(model)); }
public void Delete() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblState state = (from s in oDC.tblStates where s.Id == Id select s).FirstOrDefault(); oDC.tblStates.DeleteOnSubmit(state); oDC.SubmitChanges(); } }
public SavingResult SaveNewRecord(tblState SaveModel) { SavingResult res = new SavingResult(); //-- Perform Validation //res.ExecutionResult = eExecutionResult.ValidationError; //res.ValidationError = "Validation error message"; //return res; //-- using (dbVisionEntities db = new dbVisionEntities()) { //tblState SaveModel; if (SaveModel.StateName == "") { res.ValidationError = "Can not accept blank value. Please enter state name."; res.ExecutionResult = eExecutionResult.ValidationError; return(res); } else if (IsDuplicateRecord(SaveModel.StateName, SaveModel.StateID, SaveModel.CountryID, db)) { res.ValidationError = "Can not accept duplicate value. The State Name is already exists."; res.ExecutionResult = eExecutionResult.ValidationError; return(res); } if (SaveModel.StateID == 0) // New Entry { SaveModel.rcuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID; SaveModel.rcdt = DateTime.Now; db.tblStates.Add(SaveModel); } else { SaveModel.reuid = Model.CommonProperties.LoginInfo.LoggedinUser.UserID; SaveModel.redt = DateTime.Now; db.tblStates.Attach(SaveModel); db.Entry(SaveModel).State = System.Data.Entity.EntityState.Modified; } //-- try { db.SaveChanges(); res.PrimeKeyValue = SaveModel.StateID; res.ExecutionResult = eExecutionResult.CommitedSucessfuly; } catch (Exception ex) { CommonFunctions.GetFinalError(res, ex); } } return(res); }
public IHttpActionResult GettblState(int id) { tblState tblState = db.tblStates.Find(id); if (tblState == null) { return(NotFound()); } return(Ok(tblState)); }
public ActionResult Edit([Bind(Include = "StateID,CountryID,StateName")] tblState tblState) { if (ModelState.IsValid) { db.Entry(tblState).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CountryID = new SelectList(db.tblCountries, "CountryID", "CountryName", tblState.CountryID); return(View(tblState)); }
public IHttpActionResult PosttblState(tblState tblState) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.tblStates.Add(tblState); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = tblState.Id }, tblState)); }
public ActionResult Delete(int id) { if (Session["AdminUser"] == null) { return(RedirectToAction("Login", "Home")); } tblState model = db.tblStates.Find(id); db.tblStates.Remove(model); db.SaveChanges(); return(RedirectToAction("Index")); }
public void Create() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblState s = new tblState(); s.Id = Guid.NewGuid(); s.StateName = StateName; oDC.tblStates.InsertOnSubmit(s); oDC.SubmitChanges(); } }
public void Update() { using (WorkWithMeDataContext oDC = new WorkWithMeDataContext()) { tblState state = (from s in oDC.tblStates where s.Id == Id select s).FirstOrDefault(); state.Id = Id; state.StateName = StateName; oDC.SubmitChanges(); } }
public ActionResult Create([Bind(Include = "StateID,CountryID,StateName")] tblState tblState) { if (ModelState.IsValid) { db.tblStates.Add(tblState); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CountryID = new SelectList(db.tblCountries, "CountryID", "CountryName", tblState.CountryID); return(View(tblState)); }
public async Task <IActionResult> Create([Bind("state_Id,country_Id,State")] tblState tblState) { if (ModelState.IsValid) { _context.Add(tblState); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["country_Id"] = new SelectList(_context.tblCountry, "country_Id", "country_Name", tblState.country_Id); return(View(tblState)); }
private void SetValuesToControls() { if (!string.IsNullOrEmpty(hdnPKID.Value) && hdnPKID.Value != "") { objState = new tblState(); if (objState.LoadByPrimaryKey(Convert.ToInt32(hdnPKID.Value))) { txtState.Text = objState.AppState.ToString(); ddlCountry.SelectedValue = objState.s_AppCountryID; } objState = null; } }
public int InsertStateDetails(string stateName, int countryId, bool IsActive) { tblState state = new tblState() { StateName = stateName, CountryId = countryId, IsActive = IsActive }; db.tblStates.Add(state); return(db.SaveChanges()); }
/// <summary> /// Create a new tblState object. /// </summary> /// <param name="stateID">Initial value of StateID.</param> public static tblState CreatetblState(short stateID) { tblState tblState = new tblState(); tblState.StateID = stateID; return tblState; }
/// <summary> /// There are no comments for tblState in the schema. /// </summary> public void AddTotblState(tblState tblState) { base.AddObject("tblState", tblState); }