public static ProductionUnit GetProductionUnit(int?ProductionUnitId)
{
ProductionUnit ProductionUnit = null;
using (SmizeeContext Context = new SmizeeContext())
{
ProductionUnit = Context.ProductionUnits.FirstOrDefault(cp => cp.ProductionUnitID == ProductionUnitId);
}
return(ProductionUnit);
}
public static void CreateRecord(string description, int AreaId, int CompanyId, int SectorId, int?Hectares)
{
using (var db = new Models.SmizeeContext())
{
ProductionUnit productionUnit = db.ProductionUnits.FirstOrDefault(cp => cp.Description == description);
if (productionUnit != null)
{
throw new Exception("Duplicate Record!");
}
ProductionUnit entity = new ProductionUnit();
entity.Description = description;
entity.AreaID = AreaId;
entity.CompanyID = CompanyId;
entity.SectorID = SectorId;
entity.Hectares = Hectares;
db.ProductionUnits.Add(entity);
db.SaveChanges();
}
}