public int Save(Entities.Region e)
{
DataLayer.Region region = (from r in Context.Regions
where r.Id == e.Id
select r).FirstOrDefault();
bool isNew = false;
if (region == null)
{
region = new DataLayer.Region();
isNew = true;
}
region.Text = e.Text;
region.CityId = e.CityId;
region.DistrictId = e.DistrictId;
region.Status = e.Status;
region.NeighborId = e.NeighborId;
try
{
if (isNew)
{
Context.Regions.InsertOnSubmit(region);
}
Context.SubmitChanges();
return(region.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 Update(Entities.Region e)
{
DataLayer.Region region = (from p in Context.Regions
where p.Id == e.Id
select p).FirstOrDefault();
if (region == null)
{
return((int)Enums.Errors.NOT_EXIST);
}
region.Text = e.Text;
region.CityId = e.CityId;
region.DistrictId = e.DistrictId;
region.Status = e.Status;
region.NeighborId = e.NeighborId;
try
{
Context.SubmitChanges();
return(region.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.Region e)
{
DataLayer.Region p = new DataLayer.Region();
p.Text = e.Text;
p.CityId = e.CityId;
p.DistrictId = e.DistrictId;
p.Status = e.Status;
p.NeighborId = e.NeighborId;
try
{
Context.Regions.InsertOnSubmit(p);
Context.SubmitChanges();
}
catch (Exception ex)
{
string data = className + ex.Message.ToString();
Logs.LogWrite(string.Format(Configs.ERROR_ACTION, data));
return((int)Enums.Errors.INSERT_ERROR);
}
return(p.Id);
}
public int Delete(int id)
{
try
{
DataLayer.Region region = (from u in Context.Regions
where u.Id == id
select u).FirstOrDefault();
if (region != null)
{
Context.Regions.DeleteOnSubmit(region);
Context.SubmitChanges();
return(id);
}
else
{
return((int)Enums.Errors.NOT_EXIST);
}
}
catch
{
return((int)Enums.Errors.DELETE_ERROR);
}
}
