public string UpdatePrintoutLayout(string PrintoutName, string NewLayout, string UserID)
{
try
{
var message = "";
var context = new EMSDataModel();
var printout = new USER_PRINTOUT_LAYOUT();
var printoutvariable = context.PRINTOUT_VARIABLE.Where(w => w.PRINTOUT_LAYOUT.NAME == PrintoutName);
if (printoutvariable.Any())
{
printout = context.USER_PRINTOUT_LAYOUT.Where(w => w.PRINTOUT_LAYOUT.NAME == PrintoutName && w.USER_ID == UserID).FirstOrDefault();
var isVariableOk = true;
var layout = printout.LAYOUT;
foreach (var variable in printoutvariable)
{
if (!NewLayout.Contains(variable.NAME))
{
isVariableOk = false;
}
}
isVariableOk = true;
if (isVariableOk)
{
printout.LAYOUT = NewLayout;
printout.MODIFIED_DATE = DateTime.Now;
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 USER_PRINTOUT_LAYOUT GeneratePrintout(string PrintoutName, Dictionary <string, string> Parameters, string UserID)
{
try
{
var context = new EMSDataModel();
var PrintoutLayout = new USER_PRINTOUT_LAYOUT();
var printoutvariables = context.PRINTOUT_VARIABLE.Where(w => w.PRINTOUT_LAYOUT.NAME == PrintoutName);
PrintoutLayout = GetPrintoutLayout(PrintoutName, UserID).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);
}
}
public USER_PRINTOUT_LAYOUT InsertUserPrintOutLayout(string PrintoutName, string UserID)
{
try
{
var context = new EMSDataModel();
var UserPrintout = new USER_PRINTOUT_LAYOUT();
var Printouts = context.PRINTOUT_LAYOUT.Where(w => w.NAME == PrintoutName);
if (Printouts.Any())
{
var Printout = Printouts.FirstOrDefault();
UserPrintout.PRINTOUT_LAYOUT_ID = Printout.PRINTOUT_LAYOUT_ID;
UserPrintout.USER_ID = UserID;
UserPrintout.LAYOUT = Printout.LAYOUT;
UserPrintout.MODIFIED_DATE = DateTime.Now;
context.USER_PRINTOUT_LAYOUT.Add(UserPrintout);
context.SaveChanges();
}
return(UserPrintout);
}
catch (Exception ex)
{
throw this.HandleException("Exception occured on Insert Printout Layout. See Inner Exception property to see details", ex);
}
}
