public async Task <SelectedNumbersDto> UpdateSelectedNumber(SelectedNumbersDto number)
{
using (CellularCompanyContext db = new CellularCompanyContext())
{
try
{
if (number != null)
{
SelectedNumbersEntity entity = number.ToModel();
entity.Id = number.Id;
db.SelectedNumbers.Attach(entity);
foreach (var propName in db.Entry(entity).CurrentValues.PropertyNames)
{
if (propName != "Id")
{
db.Entry(entity).Property(propName).IsModified = true;
}
}
await db.SaveChangesAsync();
return(entity.ToDto());
}
return(null);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(null);
}
}
}
public IEnumerable <string> GetLineSelectedNumbers(int lineId)
{
using (CellularCompanyContext db = new CellularCompanyContext())
{
try
{
List <string> list = new List <string>();
SelectedNumbersEntity entity = db.SelectedNumbers.Where(s => s.Line.LineId == lineId).FirstOrDefault();
foreach (var propName in db.Entry(entity).CurrentValues.PropertyNames)
{
if (propName.EndsWith("Number"))
{
if (db.Entry(entity).Property(propName).CurrentValue != null)
{
list.Add(db.Entry(entity).Property(propName).CurrentValue.ToString());
}
}
}
return(list);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(null);
}
}
}
public static SelectedNumbersDto ToDto(this SelectedNumbersEntity numbers)
{
return(new SelectedNumbersDto()
{
FirstNumber = numbers.FirstNumber,
Id = numbers.Id,
SecondNumber = numbers.SecondNumber,
ThirdNumber = numbers.ThirdNumber,
//PackageIncludes=numbers.PackageIncludes.Select(p=>p.ToDto()).ToList()
});
}
public async Task <SelectedNumbersDto> CreateSelectedNumber(SelectedNumbersDto number)
{
using (CellularCompanyContext db = new CellularCompanyContext())
{
try
{
if (number != null)
{
SelectedNumbersEntity entity = number.ToModel();
db.SelectedNumbers.Add(entity);
await db.SaveChangesAsync();
return(entity.ToDto());
}
return(null);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
return(null);
}
}
}
