public string UpdatePrintoutLayout_Old(string PrintoutName, string NewLayout) { try { var message = ""; var context = new EMSDataModel(); var printout = new PRINTOUT_LAYOUT(); var printoutvariable = context.PRINTOUT_VARIABLE.Where(w => w.PRINTOUT_LAYOUT.NAME == PrintoutName); if (printoutvariable.Any()) { printout = printoutvariable.Select(s => s.PRINTOUT_LAYOUT).FirstOrDefault(); var isVariableOk = true; var layout = printout.LAYOUT; foreach (var variable in printoutvariable) { if (!layout.Contains(variable.NAME)) { isVariableOk = false; } } if (isVariableOk) { printout.LAYOUT = NewLayout; context.SaveChanges(); } else { message = "The variables are incomplete. Please make sure the variables are not deleted."; } } else { message = "Cannot find variables in database."; } return(message); } catch (Exception ex) { throw this.HandleException("Exception occured on Update Printout Layout. See Inner Exception property to see details", ex); } }
public PRINTOUT_LAYOUT GeneratePrintout_Old(string PrintoutName, Dictionary <string, string> Parameters) { try { var context = new EMSDataModel(); var PrintoutLayout = new PRINTOUT_LAYOUT(); var printoutvariables = context.PRINTOUT_VARIABLE.Where(w => w.PRINTOUT_LAYOUT.NAME == PrintoutName); PrintoutLayout = GetPrintoutLayout_Old(PrintoutName).FirstOrDefault(); var layout = PrintoutLayout.LAYOUT; foreach (var variable in printoutvariables) { layout = layout.Replace(String.Format("#{0}", variable.NAME), Parameters[variable.NAME]); } PrintoutLayout.LAYOUT = layout; return(PrintoutLayout); } catch (Exception ex) { throw this.HandleException("Exception occured on Generate Printout. See Inner Exception property to see details", ex); } }