public static OperationalLicensesForm GetFormById(int operationalLicensesFormId) { OperationalLicensesForm entity = null; using (SmizeeContext Context = new SmizeeContext()) { entity = Context.OperationalLicensesForms.FirstOrDefault(f => f.OperationalLicensesFormID == operationalLicensesFormId); // force context to get Form string code = entity.Form.Periodicity.Code; int functionalAreaID = entity.Form.FormType.FunctionalAreaID; } return(entity); }
public static void CreateRecord(int formId, string userName) { using (var db = new Models.SmizeeContext()) { OperationalLicensesForm entity = new OperationalLicensesForm(); entity.StateID = 1; entity.FormID = formId; entity.SubmitDate = DateTime.Now; entity.SubmitUserName = userName; db.OperationalLicensesForms.Add(entity); db.SaveChanges(); } }
public static bool CheckFormsByFormDate(int formId, int productionUnitId, DateTime formDate) { bool result = false; OperationalLicensesForm entity = null; using (SmizeeContext Context = new SmizeeContext()) { entity = Context.OperationalLicensesForms.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 OperationalLicensesFormId = 0; OperationalLicensesForm entity = new OperationalLicensesForm(); using (var db = new Models.SmizeeContext()) { entity.FormID = formId; entity.StateID = 1; entity.PeriodNumber = periodNumber; entity.FormDate = formDate; db.OperationalLicensesForms.Add(entity); db.SaveChanges(); OperationalLicensesFormId = entity.OperationalLicensesFormID; } return(OperationalLicensesFormId); }