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);
}
