public bool DeleteStandard(int StandardID)
{
AutomationStandardsContext db = new AutomationStandardsContext();
var Standards = db.Standard.Where(d => d.StandardID == StandardID).ToList();
if (Standards.Count > 0)
{
var Configs = db.StandardConfig.Where(c => c.StandardID == StandardID).ToList();
foreach (var Config in Configs)
{
db.StandardConfig.Remove(Config);
db.SaveChanges();
}
db.Standard.Remove(Standards.First());
try
{
db.SaveChanges();
//DELETE TABLE
StandardSQLManagement sql = new StandardSQLManagement();
bool SQLOK = sql.DeleteStandardTable(Standards.First().DBTableName);
return(SQLOK);
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
//GlobalFunctions gf = new //GlobalFunctions();
//gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
}
return(true);
}
public bool DeleteStandardDataType(int DataTypeID)
{
AutomationStandardsContext db = new AutomationStandardsContext();
var DataTypes = db.StandardDataType.Where(d => d.DataTypeID == DataTypeID).ToList();
if (DataTypes.Count > 0)
{
db.StandardDataType.Remove(DataTypes.First());
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
//GlobalFunctions gf = new //GlobalFunctions();
//gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
}
return(true);
}
public bool InsertStandardDataType(StandardDataTypeModel model)
{
AutomationStandardsContext db = new AutomationStandardsContext();
StandardDataType Result = new StandardDataType();
Result.DataTypeName = model.StandardDataTypeName;
Result.SQLDataType = model.SQLDataType;
db.StandardDataType.Add(Result);
try
{
db.SaveChanges();
model.StandardDataTypeID = Result.DataTypeID;
return(true);
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
//GlobalFunctions gf = new //GlobalFunctions();
//gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
}
public bool UpdateStandardGroup(StandardGroupModel model)
{
AutomationStandardsContext db = new AutomationStandardsContext();
StandardGroup Result = db.StandardGroup.First(d => d.StandardGroupID == model.StandardGroupID);
Result.StandardGroupName = model.StandardGroupName;
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
//GlobalFunctions gf = new //GlobalFunctions();
//gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
}
//public bool NotifyStandardOwner(string EntryType, FormCollection fc, List<StandardConfigModel> Configs, StandardModel StandardInfo, string CurrentUser)
//{
// int StandardID = Convert.ToInt32(fc["StandardID"]);
// string RecordID = fc["ID"];
// string To, Subject, Body, Type;
// ActiveDirectoryUserInfo UserInfo = new ActiveDirectoryUserInfo(CurrentUser);
// To = StandardInfo.OwnerEmail;
// Subject = "OneClick Standard - " + StandardInfo.StandardName;
// Body = "";
// Type = "";
// #region Build Body
// switch (EntryType)
// {
// case "INSERT":
// Subject = Subject + " - New Standard Added";
// Type = "Inserted";
// Body = "A new standard has been added to <b>" + StandardInfo.StandardName + "</b>. Below is the new standard added.<br><br><br>";
// Body += @"<table class=""details-table"" width=""80%""><tr><td class=""titles"" style=""font-family:Calibri,Arial;"">Field</td><td class=""titles"" style=""font-family:Calibri,Arial;"">New Value</td></tr>";
// foreach (var formKey in fc.Keys) //AllKeys)
// {
// List<StandardConfigModel> foundConfig = Configs.Where(c => c.FieldName == formKey).ToList();
// if (foundConfig.Count > 0)
// {
// StandardConfigModel config = foundConfig.First();
// string newValue;
// if (config.AllowMultiSelect)
// {
// newValue = ";" + fc[config.FieldName].Replace(",", ";") + ";";
// }
// else
// {
// newValue = fc[config.FieldName];
// }
// Body += @"<tr><td class=""values"" style=""font-family:Calibri,Arial;"">" + config.DisplayName + @"</td><td class=""values"" style=""font-family:Calibri,Arial;"">" + newValue + "</td></tr>";
// }
// }
// Body += "</table>";
// break;
// case "UPDATE":
// DataRow OldData = GetStandardRow(StandardInfo.DBTableName, RecordID);
// Subject = Subject + " - Existing Standard Updated";
// Type = "Updated";
// Body = "An existing standard has been updated to <b>" + StandardInfo.StandardName + "</b>. Below is the old and new standard values.<br><br><br>";
// Body += @"<table class=""details-table"" width=""80%""><tr><td class=""titles"" style=""font-family:Calibri,Arial;"">Field</td><td class=""titles"" style=""font-family:Calibri,Arial;"">Old Value</td><td class=""titles"" style=""font-family:Calibri,Arial;"">New Value</td></tr>";
// foreach (var formKey in fc.Keys) //AllKeys)
// {
// List<StandardConfigModel> foundConfig = Configs.Where(c => c.FieldName == formKey).ToList();
// if (foundConfig.Count > 0)
// {
// StandardConfigModel config = foundConfig.First();
// string newValue;
// if (config.AllowMultiSelect)
// {
// newValue = ";" + fc[config.FieldName].Replace(",", ";") + ";";
// }
// else
// {
// newValue = fc[config.FieldName];
// }
// string OldValue = OldData[config.FieldName].ToString();
// Body += @"<tr><td class=""values"" style=""font-family:Calibri,Arial;"">" + config.DisplayName + @"</td><td class=""values"" style=""font-family:Calibri,Arial;"">" + OldValue + @"</td><td class=""values"" style=""font-family:Calibri,Arial;"">" + newValue + "</td></tr>";
// }
// }
// Body += "</table>";
// break;
// case "DELETE":
// DataRow DeletedData = GetStandardRow(StandardInfo.DBTableName, RecordID);
// Subject = Subject + " - Standard Deleted";
// Type = "Deleted";
// Body = "A standard has been deleted from <b>" + StandardInfo.StandardName + "</b>. Below is the standard that was deleted.<br><br><br>";
// Body += @"<table class=""details-table"" width=""80%""><tr><td class=""titles"" style=""font-family:Calibri,Arial;"">Field</td><td class=""titles"" style=""font-family:Calibri,Arial;"">Deleted Value</td></tr>";
// foreach (var config in Configs.OrderBy(c => c.SortOrder))
// {
// string DeletedValue = DeletedData[config.FieldName].ToString();
// Body += @"<tr><td class=""values"" style=""font-family:Calibri,Arial;"">" + config.DisplayName + @"</td><td class=""values"" style=""font-family:Calibri,Arial;"">" + DeletedValue + "</td></tr>";
// }
// Body += "</table>";
// break;
// }
// #endregion
// NotificationTemplateModel tempinfo = new NotificationTemplateModel().SelectSingleNotificationTemplateByName("Standard");
// Body = tempinfo.NotificationBody.Replace("{#NotificationBody#}", Body)
// .Replace("{#Type#}", Type)
// .Replace("{#ChangedBy#}", UserInfo.FirstName + " " + UserInfo.LastName)
// .Replace("{#StandardName#}", StandardInfo.StandardName)
// .Replace("{#RequestUrl#}", "http://util.obs.org/OneClick/Standard/Viewer/" + StandardInfo.StandardName);
// wsESEUtil.ESEUtilitySoapClient ws = new wsESEUtil.ESEUtilitySoapClient();
// bool result = ws.sendEmail(Subject, Body, To, true, "eseautomation", "", "", "", "");
// return result;
//}
public bool SetStandardVersionValue(int StandardID)
{
AutomationStandardsContext db = new AutomationStandardsContext();
var Standards = db.Standard.Where(d => d.StandardID == StandardID).ToList();
if (Standards.Count > 0)
{
Standard CurrentStandard = Standards.First();
int NewVersion = CurrentStandard.VersionValue + 1;
CurrentStandard.VersionValue = NewVersion;
db.SaveChanges();
}
return(true);
}
public Standard SelectSingleStandardAsDbStandard(int StandardID)
{
AutomationStandardsContext db = new AutomationStandardsContext();
StandardModel Result = new StandardModel();
//if (StandardID != 0)
//{
// Result = (from d in db.Standard
// where d.StandardID == StandardID
// select new StandardModel
// {
// StandardID = d.StandardID,
// StandardName = d.StandardName,
// StandardDefinition = d.StandardDefinition,
// DBTableName = d.DBTableName,
// StandardGroupID = d.StandardGroupID,
// StandardGroupName = d.StandardGroup.StandardGroupName,
// ManageRoles = d.ManageRoles,
// ViewerRoles = d.ViewerRoles,
// VersionConfig = d.VersionConfig,
// VersionValue = d.VersionValue,
// Tags = d.Tags,
// NotifiyOwner = d.NotifiyOwner,
// OwnerEmail = d.OwnerEmail,
// UsageCount = d.UsageCount
// }).First();
//}
Standard CurrentStandard = db.Standard.First(s => s.StandardID == StandardID);
CurrentStandard.UsageCount = CurrentStandard.UsageCount + 1;
try
{
db.SaveChanges();
}
catch
{
string body = "";
body += string.Format("Failed to increment usage counter for Standard: \"{0}\" ID: \"{1}\" ", CurrentStandard.DBTableName, StandardID);
//GlobalFunctions gf = new //GlobalFunctions();
//gf.SendErrorModelEmail(this.GetType().Name, body);
return(CurrentStandard);
}
return(Result);
}
public bool SetStandardConfigSortOrder(int ConfigID, int SortOrder)
{
AutomationStandardsContext db = new AutomationStandardsContext();
var ConfigInfo = (from f in db.StandardConfig
where f.StandardConfigID == ConfigID
select f).ToList();
if (ConfigInfo.Count == 0)
{
return(false);
}
var Config = ConfigInfo.First();
Config.SortOrder = SortOrder;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
////GlobalFunctions gf = new //GlobalFunctions();
////gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
return(true);
}
public bool UpdateStandard(StandardModel model)
{
AutomationStandardsContext db = new AutomationStandardsContext();
Standard Result = db.Standard.First(d => d.StandardID == model.StandardID);
Result.StandardName = model.StandardName;
Result.StandardGroupID = model.StandardGroupID;
Result.StandardDefinition = model.StandardDefinition;
Result.ManageRoles = model.ManageRoles;
Result.ViewerRoles = model.ViewerRoles;
Result.VersionConfig = model.VersionConfig;
Result.VersionValue = model.VersionValue;
Result.Tags = model.Tags;
Result.NotifiyOwner = model.NotifiyOwner;
Result.OwnerEmail = model.OwnerEmail;
try
{
db.SaveChanges();
return(true);
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
//GlobalFunctions gf = new //GlobalFunctions();
//gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
}
public bool SetStandardVersion(int StandardID)
{
AutomationStandardsContext db = new AutomationStandardsContext();
var Standards = db.Standard.Where(d => d.StandardID == StandardID).ToList();
if (Standards.Count > 0)
{
Standard CurrentStandard = Standards.First();
int NewVersion = CurrentStandard.VersionConfig + 1;
CurrentStandard.VersionConfig = NewVersion;
foreach (StandardConfig config in CurrentStandard.StandardConfig)
{
config.VersionNumber = NewVersion;
}
db.SaveChanges();
}
return(true);
}
public bool InsertStandard(StandardModel model)
{
bool OkToCreate = false;
AutomationStandardsContext db = new AutomationStandardsContext();
var CurrentStds = (from s in db.Standard where s.DBTableName.ToLower() == model.DBTableName.ToLower() select s).ToList();
if (CurrentStds.Count == 0)
{
OkToCreate = true;
}
if (OkToCreate)
{
Standard Result = new Standard();
Result.StandardName = model.StandardName;
Result.DBTableName = model.DBTableName;
Result.StandardDefinition = model.StandardDefinition;
Result.StandardGroupID = model.StandardGroupID;
Result.ManageRoles = model.ManageRoles;
Result.ViewerRoles = model.ViewerRoles;
Result.VersionConfig = model.VersionConfig;
Result.VersionValue = model.VersionValue;
Result.Tags = model.Tags;
Result.NotifiyOwner = model.NotifiyOwner;
Result.OwnerEmail = model.OwnerEmail;
Result.UsageCount = 0;
db.Standard.Add(Result);
try
{
db.SaveChanges();
model.StandardID = Result.StandardID;
//Create Table in DB with MODEL Values
StandardSQLManagement sql = new StandardSQLManagement();
bool SQLOK = sql.CreateStandardTable(model.DBTableName);
return(SQLOK);
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
//GlobalFunctions gf = new //GlobalFunctions();
//gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
}
return(true);
}
public bool UpdateStandardConfig(StandardConfigModel model)
{
AutomationStandardsContext db = new AutomationStandardsContext();
StandardConfig Result = db.StandardConfig.First(d => d.StandardConfigID == model.StandardConfigID);
Standard st = db.Standard.First(x => x.StandardID == model.StandardID);
Result.Standard = st;
bool RenameCol = false;
string OldCol = "", NewCol = "", TableName = "";
if (Result.FieldName != model.FieldName)
{
RenameCol = true;
OldCol = Result.FieldName;
NewCol = model.FieldName;
TableName = Result.Standard.DBTableName;
}
Result.DisplayName = model.DisplayName;
Result.FieldName = model.FieldName;
Result.SortOrder = model.SortOrder;
Result.VersionNumber = model.VersionNumber;
Result.UseToolTip = model.UseToolTip;
Result.ToolTip = model.ToolTip;
Result.UseStandardData = model.UseStandardData;
Result.AllowMultiSelect = model.AllowMultiSelect;
Result.StandardLUID = model.StandardLUID;
Result.StandardLUValue = model.StandardLUValue;
Result.StandardUseFilter = model.StandardUseFilter;
Result.StandardFilterSQL = model.StandardFilterSQL;
try
{
db.SaveChanges();
if (RenameCol)
{
StandardSQLManagement sql = new StandardSQLManagement();
bool SQLOK = sql.RenameColumn(TableName, OldCol, NewCol);
return(SQLOK);
}
SetStandardVersion(model.StandardID);
return(true);
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
////GlobalFunctions gf = new //GlobalFunctions();
////gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
}
public bool InsertStandardConfig(StandardConfigModel model)
{
AutomationStandardsContext db = new AutomationStandardsContext();
StandardConfig Result = new StandardConfig();
Result.StandardID = model.StandardID;
//Result.FieldName = model.FieldName;
Result.FieldName = model.DisplayName.Replace(" ", "");
Result.DisplayName = model.DisplayName;
Result.DataTypeID = model.DataTypeID;
Result.SortOrder = model.SortOrder;
Result.VersionNumber = model.VersionNumber;
Result.UseToolTip = model.UseToolTip;
Result.ToolTip = model.ToolTip;
Result.UseStandardData = model.UseStandardData;
Result.AllowMultiSelect = model.AllowMultiSelect;
Result.StandardLUID = model.StandardLUID;
Result.StandardLUValue = model.StandardLUValue;
Result.StandardUseFilter = model.StandardUseFilter;
Result.StandardFilterSQL = model.StandardFilterSQL;
db.StandardConfig.Add(Result);
try
{
db.SaveChanges();
model.StandardConfigID = Result.StandardConfigID;
//Add Column To the Table
StandardSQLManagement sql = new StandardSQLManagement();
var Standard = db.Standard.First(s => s.StandardID == model.StandardID);
var DBType = db.StandardDataType.First(d => d.DataTypeID == model.DataTypeID);
string DefaultValue = "";
bool AllowNull = true;
if (DBType.SQLDataType == "BIT")
{
DefaultValue = "(0)";
}
sql.AddColumn(Standard.DBTableName, Result.FieldName, DBType.SQLDataType, DefaultValue, AllowNull);
SetStandardVersion(model.StandardID);
return(true);
}
catch (DbEntityValidationException ex)
{
string body = "";
foreach (var eve in ex.EntityValidationErrors)
{
body += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State);
body += "<br>";
foreach (var ve in eve.ValidationErrors)
{
body += string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage);
}
}
////GlobalFunctions gf = new //GlobalFunctions();
////gf.SendErrorModelEmail(this.GetType().Name, body);
return(false);
}
}