public static OperationalForm GetFormById(int operationalFormId)
{
OperationalForm entity = null;
using (SmizeeContext Context = new SmizeeContext())
{
entity = Context.OperationalForms.FirstOrDefault(f => f.OperationalFormID == operationalFormId);
// force context to get Form
string code = entity.Form.Periodicity.Code;
int functionalAreaID = entity.Form.FormType.FunctionalAreaID;
}
return(entity);
}
public static bool CheckFormsByFormDate(int formId, int productionUnitId, DateTime formDate)
{
bool result = false;
OperationalForm entity = null;
using (SmizeeContext Context = new SmizeeContext())
{
entity = Context.OperationalForms.FirstOrDefault(fef => (fef.FormID == formId) & (fef.FormDate == formDate));
if (entity != null)
{
result = true;
}
}
return(result);
}
public static int CreateForm(int formId, int productionUnitId, int periodNumber, DateTime formDate)
{
int OperationalFormId = 0;
OperationalForm entity = new OperationalForm();
using (var db = new Models.SmizeeContext())
{
entity.FormID = formId;
entity.StateID = 1;
entity.PeriodNumber = periodNumber;
entity.FormDate = formDate;
db.OperationalForms.Add(entity);
db.SaveChanges();
OperationalFormId = entity.OperationalFormID;
}
return(OperationalFormId);
}
public static void CreateRecord(int formId, string userName, int?numeroHectaresQuadrante1, int?numeroHectaresQuadrante2,
int?numeroHectaresQuadrante3, int?numeroHectaresQuadrante4, int?numeroHectaresEspacoUtilizado,
int?numeroTotalUnidadesProdutivas)
{
using (var db = new Models.SmizeeContext())
{
OperationalForm entity = new OperationalForm();
entity.StateID = 1;
entity.FormID = formId;
entity.UsedSpace = numeroHectaresEspacoUtilizado;
entity.ProductionUnitsTotalNumber = numeroTotalUnidadesProdutivas;
entity.Quadrant1HectaresNumber = numeroHectaresQuadrante1;
entity.Quadrant2HectaresNumber = numeroHectaresQuadrante2;
entity.Quadrant3HectaresNumber = numeroHectaresQuadrante3;
entity.Quadrant4HectaresNumber = numeroHectaresQuadrante4;
entity.SubmitDate = DateTime.Now;
entity.SubmitUserName = userName;
db.OperationalForms.Add(entity);
db.SaveChanges();
}
}
