public ActionResult Edit(int id)
{
try
{
ViewBag.Saved = false;
StayBazar.Areas.Admin.Models.CityModel mbt = new CityModel()
{
CityId = 0
};
CLayer.City pt = BLayer.City.Get(id);
if (pt != null)
{
mbt = new CityModel()
{
CityId = pt.CityId,
Name = pt.Name,
StateId = pt.StateId,
ForListing = pt.ForListing,
Keywords = pt.Keywords
}
}
;
return(PartialView("_Edit", mbt));
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
return(Redirect("~/Admin/ErrorPage"));
}
}
public ActionResult Edit(StayBazar.Areas.Admin.Models.CityModel data)
{
try
{
if (ModelState.IsValid)
{
CLayer.City pt = new CLayer.City()
{
CityId = data.CityId,
Name = data.Name,
StateId = data.StateId,
ForListing = data.ForListing,
Keywords = data.Keywords
};
BLayer.City.Save(pt);
ViewBag.Saved = true;
}
else
{
ViewBag.Saved = false;
}
return(RedirectToAction("Index", new { id = data.StateId }));
}
catch (Exception ex)
{
Common.LogHandler.HandleError(ex);
return(Redirect("~/Admin/ErrorPage"));
}
}
public int UpdateGDSCity(int StateID, string City = "Others")
{
int result = 0;
string sql = "SELECT COUNT(*) FROM City WHERE StateID='" + StateID + "' and name='" + City + "'";
object obj = Connection.ExecuteSQLQueryScalar(sql);
if (Connection.ToInteger(obj) < 1)
{
CLayer.City objCity = new CLayer.City();
objCity.CityId = 0;
objCity.Name = City;
objCity.StateId = StateID;
objCity.ForListing = true;
objCity.Keywords = City;
result = Save(objCity);
}
else
{
sql = "SELECT cityid FROM City WHERE StateID='" + StateID + "' and name='" + City + "'";
obj = Connection.ExecuteSQLQueryScalar(sql);
result = Connection.ToInteger(obj);
}
return(result);
}
public CLayer.City GetCityID(string CityName)
{
CLayer.City city = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCity", DataPlug.DataType._Varchar, CityName));
DataTable dt = Connection.GetTable("cityID_Get", param);
if (dt.Rows.Count > 0)
{
city = new CLayer.City()
{
CityId = Connection.ToInteger(dt.Rows[0]["CityId"]),
Name = Connection.ToString(dt.Rows[0]["Name"]),
StateId = Connection.ToInteger(dt.Rows[0]["StateId"]),
ForListing = Connection.ToBoolean(dt.Rows[0]["ForListing"]),
Keywords = Connection.ToString(dt.Rows[0]["Keywords"])
};
}
else
{
city = new CLayer.City()
{
CityId = 0,
Name = "",
StateId = 0,
//ForListing = Connection.ToBoolean(dt.Rows[0]["ForListing"]),
//Keywords = Connection.ToString(dt.Rows[0]["Keywords"])
};
}
return(city);
}
public int Save(CLayer.City data)
{
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCityId", DataPlug.DataType._Int, data.CityId));
param.Add(Connection.GetParameter("pName", DataPlug.DataType._Varchar, data.Name));
param.Add(Connection.GetParameter("pStateId", DataPlug.DataType._Int, data.StateId));
param.Add(Connection.GetParameter("pForListing", DataPlug.DataType._Bool, data.ForListing));
param.Add(Connection.GetParameter("pKeywords", DataPlug.DataType._Varchar, data.Keywords));
object result = Connection.ExecuteQueryScalar("city_Save", param);
return(Connection.ToInteger(result));
}
public CLayer.City Get(int?cityId)
{
CLayer.City city = null;
List <DataPlug.Parameter> param = new List <DataPlug.Parameter>();
param.Add(Connection.GetParameter("pCityId", DataPlug.DataType._Int, cityId));
DataTable dt = Connection.GetTable("city_Get", param);
if (dt.Rows.Count > 0)
{
city = new CLayer.City()
{
CityId = Connection.ToInteger(dt.Rows[0]["CityId"]),
Name = Connection.ToString(dt.Rows[0]["Name"]),
StateId = Connection.ToInteger(dt.Rows[0]["StateId"]),
ForListing = Connection.ToBoolean(dt.Rows[0]["ForListing"]),
Keywords = Connection.ToString(dt.Rows[0]["Keywords"])
};
}
return(city);
}
public static int Save(CLayer.City data)
{
DataLayer.City city = new DataLayer.City();
data.Validate();
return(city.Save(data));
}
