public OdometreStatus GetOdometreStatusByNameOrInsert(string _name)
{
try
{
using (var context = new VeraEntities())
{
var OdometreStatus = context.OdometreStatus.FirstOrDefault(x => x.Name.Trim() == _name.Trim() && x.Status > 0);
if (OdometreStatus == null)
{
OdometreStatus = new OdometreStatus()
{
Name = _name.Trim(),
Status = 1
};
context.OdometreStatus.Add(OdometreStatus);
context.SaveChanges();
return(OdometreStatus);
}
return(OdometreStatus);
}
}
catch (Exception exc)
{
throw exc;
}
}
private void UpdateObject(OdometreStatus _newOdometreStatus, ref OdometreStatus _oldOdometreStatus)
{
try
{
foreach (PropertyInfo OdometreStatusPropInfo in _newOdometreStatus.GetType().GetProperties().ToList())
{
_oldOdometreStatus.GetType().GetProperty(OdometreStatusPropInfo.Name).SetValue(_oldOdometreStatus, _newOdometreStatus.GetType().GetProperty(OdometreStatusPropInfo.Name).GetValue(_newOdometreStatus));
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
public OdometreStatus AddNewOdometreStatus(OdometreStatus _OdometreStatus)
{
try
{
using (var context = new VeraEntities())
{
context.OdometreStatus.Add(_OdometreStatus);
int numOfInserted = context.SaveChanges();
return(numOfInserted > 0 ? _OdometreStatus : null);
}
}
catch (Exception)
{
throw;
}
}
public OdometreStatus UpdateOdometreStatus(OdometreStatus _OdometreStatus)
{
try
{
using (var context = new VeraEntities())
{
var oldOdometreStatus = context.OdometreStatus.FirstOrDefault(u => u.Id == _OdometreStatus.Id);
if (oldOdometreStatus != null)
{
UpdateObject(_OdometreStatus, ref oldOdometreStatus);
var numberOfUpdatedOdometreStatus = context.SaveChanges();
return(numberOfUpdatedOdometreStatus > 0 ? _OdometreStatus : null);
}
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
