public string InsertOrUpdate(CityModel CM)
{
string result = string.Empty;
bool IsExsit = false;
tbl_City City;
City = this.GetById(CM.CityID.Trim());
if (City != null)
{
IsExsit = true;
}
else
{
City = new tbl_City();
}
City.CityID = CM.CityID;
City.CityName = CM.CityName;
if (!IsExsit)
{
return(result = this.Insert(City));
}
else
{
return(result = this.Update(City));
}
}
public string InsertOrUpdateCity(CityModel CM)
{
tbl_City City = new tbl_City();
City.CityID = CM.CityID;
City.CityName = CM.CityName;
return(CityBL.InsertOrUpdate(CM));
}
public ActionResult DeleteTT(int id)
{
tbl_City tbl_City = db.tbl_City.Find(id);
db.tbl_City.Remove(tbl_City);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID_City,City_Name,CreateBy,UpdateBy,CreateDate,UpdateDate,Status")] tbl_City tbl_City)
{
if (ModelState.IsValid)
{
tbl_City.UpdateDate = DateTime.Now;
db.Entry(tbl_City).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_City));
}
public ActionResult Create([Bind(Include = "ID_City,City_Name,CreateBy,UpdateBy,CreateDate,UpdateDate,Status")] tbl_City tbl_City)
{
if (ModelState.IsValid)
{
tbl_City.CreateDate = DateTime.Now;
db.tbl_City.Add(tbl_City);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tbl_City));
}
// GET: Admin/tbl_Citys/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_City tbl_City = db.tbl_City.Find(id);
if (tbl_City == null)
{
return(HttpNotFound());
}
return(View(tbl_City));
}
public PartialViewResult GetCityById(string CityID)
{
CityModel CM = new CityModel();
tbl_City city;
city = CityBL.GetById(CityID);
if (city == null)
{
city = new tbl_City();
}
CM.CityID = city.CityID;
CM.CityName = city.CityName;
return(PartialView("~/Views/City/Partial/_CityDetailsPartial.cshtml", CM));
}
/// <summary>
/// Update City
/// </summary>
/// <param name="City"></param>
/// <returns></returns>
public string Update(tbl_City city)
{
try
{
Context.City.Update(city);
Context.City.Save();
return(city.CityID + " Updated Successfully!!");
}
catch (Exception ex)
{
//POS Log Exception to db table
return("Error in saving details, Please try again!!");
}
finally
{
// Context = null;
}
}
public long SaveUpdateCity(CityModel model)
{
ShomaRMEntities db = new ShomaRMEntities();
var userNameExists = db.tbl_City.Where(p => p.ID != model.ID && p.CityName == model.CityName).FirstOrDefault();
if (userNameExists == null)
{
if (model.ID == 0)
{
var userData = new tbl_City()
{
CityName = model.CityName,
StateID = model.StateID,
};
db.tbl_City.Add(userData);
db.SaveChanges();
model.ID = userData.ID;
}
else
{
var cityInfo = db.tbl_City.Where(p => p.ID == model.ID).FirstOrDefault();
if (cityInfo != null)
{
cityInfo.CityName = model.CityName;
cityInfo.StateID = model.StateID;
db.SaveChanges();
}
else
{
throw new Exception(model.CityName + " not exists in the system.");
}
}
return(model.ID);
}
else
{
throw new Exception(model.CityName + " already exists in the system.");
}
}
