public long UpdateCity(TblCity entity)
{
var city = da.TblCity.Find(entity.ID);
if (city != null)
{
try
{
// set data
city.Name = entity.Name;
city.Level = entity.Level;
city.Status = entity.Status;
city.PriceShip = entity.PriceShip;
city.del_flg = Constant.DeleteFlag.NON_DELETE;
city.ModifiedDate = DateTime.Now;
city.ModifiedBy = CmnEntityModel.ID;
da.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
else
{
return(0);
}
return(entity.ID);
}
public async Task <IActionResult> Edit(int id, [Bind("CityId,CityName,StateId,CreateDate,UpdateDate,IsActive,IsDelete")] TblCity tblCity)
{
if (id != tblCity.CityId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tblCity);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TblCityExists(tblCity.CityId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["StateId"] = new SelectList(_context.TblState, "StateId", "StateId", tblCity.StateId);
return(View(tblCity));
}
public async Task <DtoTblCity> AddCity(TblCity city)
{
HttpResponseMessage httpResponseMessage = await _httpClient.PostAsJsonAsync("api/CityCore/AddCity", city);
DtoTblCity ans = await httpResponseMessage.Content.ReadAsAsync <DtoTblCity>();
return(ans);
}
public DtoTblCity(TblCity city, HttpStatusCode statusEffect)
{
id = city.id;
Name = city.Name;
CountryId = city.CountryId;
StatusEffect = statusEffect;
}
public ActionResult AddCity(TblCity tblCity)
{
if (ModelState.IsValid)
{
//db.Fun_InsertCity(null, tblCity.CityName);
db.TblCities.Add(tblCity);
db.SaveChanges();
return(RedirectToAction("Create", "Home"));
}
return(View());
}
public long InsertCity(TblCity entity)
{
entity.CreatedDate = DateTime.Now;
entity.CreatedBy = CmnEntityModel.ID;
entity.ModifiedDate = DateTime.Now;
entity.ModifiedBy = CmnEntityModel.ID;
da.TblCity.Add(entity);
da.SaveChanges();
return(entity.ID);
}
public async Task <IActionResult> Create([Bind("CityId,CityName,StateId,CreateDate,UpdateDate,IsActive,IsDelete")] TblCity tblCity)
{
if (ModelState.IsValid)
{
_context.Add(tblCity);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["StateId"] = new SelectList(_context.TblState, "StateId", "StateName", tblCity.StateId);
return(View(tblCity));
}
public async Task <bool> UpdateCity(TblCity city, int logId)
{
List <object> cityAndLogId = new List <object>();
cityAndLogId.Add(city);
cityAndLogId.Add(logId);
HttpResponseMessage httpResponseMessage = await _httpClient.PostAsJsonAsync("api/CityCore/UpdateCity", cityAndLogId);
bool ans = await httpResponseMessage.Content.ReadAsAsync <bool>();
return(ans);
}
internal CityModal GetCityByCityName(string cityname)
{
TblCity tblCity = _db.TblCities.Where(t => t.CityName == cityname).FirstOrDefault();
CityModal cityModal = new CityModal()
{
CityId = tblCity.Id,
CityName = tblCity.CityName,
State = tblCity.StateName
};
return(cityModal);
}
public ActionResult Edit(CityModel model)
{
try
{
using (ManageDistrictService service = new ManageDistrictService())
{
if (ModelState.IsValid)
{
bool isNew = false;
TblCity entity = new TblCity();
if (model.ID == 0)
{
isNew = true;
model.CITY_ID = 1;
model.Level = Constant.CityLevel.District;
service.InsertCity(model);
JsonResult result = Json(new { isNew = isNew }, JsonRequestBehavior.AllowGet);
return(result);
}
else
{
isNew = false;
model.CITY_ID = 1;
model.Level = Constant.CityLevel.District;
service.UpdateCity(model);
JsonResult result = Json(new { isNew = isNew }, JsonRequestBehavior.AllowGet);
return(result);
}
}
else
{
var ErrorMessages = ModelState.Where(x => x.Value.Errors.Count > 0).Select(x => new { x.Key, x.Value.Errors }).ToArray();
}
return(new EmptyResult());
}
}
catch (Exception ex)
{
Response.StatusCode = (int)System.Net.HttpStatusCode.BadRequest;
System.Web.HttpContext.Current.Session["ERROR"] = ex;
return(new EmptyResult());
}
}
public IHttpActionResult AddCity(TblCity city)
{
var task = Task.Run(() => new CityService().AddCity(city));
if (task.Wait(TimeSpan.FromSeconds(10)))
{
if (task.Result.id != -1)
{
return(Ok(new DtoTblCity(city, HttpStatusCode.OK)));
}
else
{
return(Conflict());
}
}
return(StatusCode(HttpStatusCode.RequestTimeout));
}
public IHttpActionResult UpdateCity(List <object> cityLogId)
{
TblCity city = JsonConvert.DeserializeObject <TblCity>(cityLogId[0].ToString());
int logId = JsonConvert.DeserializeObject <int>(cityLogId[1].ToString());
var task = Task.Run(() => new CityService().UpdateCity(city, logId));
if (task.Wait(TimeSpan.FromSeconds(10)))
{
if (task.Result)
{
return(Ok(true));
}
else
{
return(Conflict());
}
}
return(StatusCode(HttpStatusCode.RequestTimeout));
}
public static List<TblCity> GetCityListData(int districtId)
{
List<TblCity> list = new List<TblCity>();
var jss = new JavaScriptSerializer();
var dict = jss.Deserialize<dynamic>(BizDictionary.GetCityListByDistrictJS(districtId));
foreach (var itm in dict) {
TblCity tbl = new TblCity();
tbl.Id = itm["Id"];
tbl.Name = itm["Name"];
tbl.CountryId = itm["CountryId"];
tbl.RegionId = itm["RegionId"];
tbl.Description = itm["Description"];
tbl.Latitude = itm["Latitude"];
tbl.Longitude = itm["Longitude"];
tbl.IsCapital = itm["IsCapital"];
list.Add(tbl);
}
var q = from p in list
orderby p.IsCapital
select p;
return q.ToList();
}
public long UpdateCity(CityModel model)
{
long res = 0;
// Declare new DataAccess object
ManageDistrictDa dataAccess = new ManageDistrictDa();
using (var transaction = new TransactionScope())
{
try
{
TblCity city = new TblCity();
city.ID = model.ID;
city.Parent_Code = model.CITY_ID;
city.Name = model.Name;
city.Level = model.Level;
city.Status = model.Status;
city.PriceShip = model.PriceShip;
city.del_flg = Constant.DeleteFlag.NON_DELETE;
res = dataAccess.UpdateCity(city);
if (res <= 0)
{
transaction.Dispose();
}
transaction.Complete();
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
finally
{
transaction.Dispose();
}
}
return(res);
}
public bool UpdateCity(TblCity city, int logId)
{
return(new CityRepo().UpdateCity(city, logId));
}
public TblCity AddCity(TblCity city)
{
return(new CityRepo().AddCity(city));
}
public bool UpdateCity(TblCity city, int logId)
{
return(new MainProvider().Update(city, logId));
}
public virtual TblCity AddCity(TblCity city)
{
return((TblCity) new MainProvider().Add(city));
}
public TblCity getCityByID(long Id)
{
TblCity product = da.TblCity.Where(s => s.ID == Id).SingleOrDefault();
return(product);
}
