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(); } }