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