public static List <string> GetUnitsForRadio()
{
var db = new UnitConverterDbEntities();
var unitsList = db.tblUnits.OrderBy(p => p.MasterUnit).Select(p => p.UnitName).ToList();
return(unitsList);
}
private static bool dbUnitExists(UnitConverterDbEntities db, tblUnit newUnit)
{
if (db.tblUnits.FirstOrDefault(p => p.UnitName == newUnit.UnitName) != null)
{
return(true);
}
return(false);
}
public static void ClearUnits()
{
var db = new UnitConverterDbEntities();
foreach (var tblItem in db.tblUnits)
{
db.tblUnits.Remove(tblItem);
}
db.SaveChanges();
}
public static void CreateUnit(DTO.UnitDTO unitDTO)
{
var db = new UnitConverterDbEntities();
var newUnit = convertToEntity(unitDTO);
if (!dbUnitExists(db, newUnit))
{
db.tblUnits.Add(newUnit);
db.SaveChanges();
}
}
private static double getMaster(string fromUnit, out string masterUnit)
{
var db = new UnitConverterDbEntities();
var unitsList = db.tblUnits.FirstOrDefault(p => p.UnitName == fromUnit);
if (unitsList != null)
{
masterUnit = unitsList.MasterUnit;
return(unitsList.ConversionFactor);
}
masterUnit = "a";
return(2);
}
public static List <string> GetUnitsForCustomRadio()
{
var db = new UnitConverterDbEntities();
var unitList = new List <string>();
foreach (var item in db.tblUnits)
{
if (!unitList.Contains(item.MasterUnit))
{
unitList.Add(item.MasterUnit);
}
}
return(unitList);
}
