public int Update(Entities.Place e)
{
DataLayer.Place place = (from p in Context.Places
where p.Id == e.Id
select p).FirstOrDefault();
if (place == null)
{
return((int)Enums.Errors.NOT_EXIST);
}
place.Text = e.Text;
place.Parent = e.Parent;
place.Type = e.Type;
place.Address = e.Address;
place.Description = e.Description;
place.Longitude = e.Longitude;
place.Latitude = e.Latitude;
place.RegionId = e.RegionId;
place.MaxAgency = e.MaxAgency;
place.MaxAgencyFree = e.MaxAgencyFree;
try
{
Context.SubmitChanges();
return(place.Id);
}
catch (Exception ex)
{
string data = className + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.EXIST);
}
}
public int Delete(int id)
{
try
{
DataLayer.Place place = (from p in Context.Places
where p.Id == id
select p).FirstOrDefault();
if (place != null)
{
List <DataLayer.Place> lstChild = (from u in Context.Places
where u.Parent == place.Id
select u).ToList();
if (lstChild != null)
{
Delete(lstChild.First().Id);
}
Context.Places.DeleteOnSubmit(place);
Context.SubmitChanges();
}
return(id);
}
catch
{
return((int)Enums.Errors.DELETE_ERROR);
}
}
public int UpdateRegion(int id, int regionId)
{
DataLayer.Place place = (from p in Context.Places
where p.Id == id
select p).FirstOrDefault();
if (place == null)
{
return((int)Enums.Errors.NOT_EXIST);
}
place.RegionId = regionId;
try
{
Context.SubmitChanges();
return(place.Id);
}
catch (Exception ex)
{
string data = className + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.EXIST);
}
}
public int Insert(Entities.Place e)
{
DataLayer.Place place = new DataLayer.Place();
place.Text = e.Text;
place.Parent = e.Parent;
place.Type = e.Type;
place.Address = e.Address;
place.Description = e.Description;
place.Longitude = e.Longitude;
place.Latitude = e.Latitude;
place.MaxAgency = e.MaxAgency;
place.MaxAgencyFree = e.MaxAgencyFree;
try
{
Context.Places.InsertOnSubmit(place);
Context.SubmitChanges();
}
catch
{
return(-1);
}
return(place.Id);
}
