//for updating equipment group table
public static bool UpdateMachineGroup(string id, string name, bool isEnabled)
{
bool result = false;
try
{
string bit = "";
if (isEnabled == true)
{
bit = "1";
}
else
{
bit = "0";
}
string query = "";
query = "select a.ID from EquipmentTable a left join tblEquipmentGroup b on a.EquipID=b.GroupName where b.ID=" + id;
DataTable dt_temp = new DataTable();
dt_temp = DBModel.CustomSelectQuery(query);
string tempID = "";
if (dt_temp != null)
{
if (dt_temp.Rows.Count > 0)
{
foreach (DataRow dr_temp in dt_temp.Rows)
{
tempID = dr_temp["ID"].ToString();
}
query = "update EquipmentTable set EquipID='" + name + "' where ID=" + tempID;
result = DBModel.ExecuteCustomQuery(query);
if (result == true)
{
query = "update tblEquipmentGroup set GroupName='" + name + "',IsEnabled=" + bit.ToString() + " where ID=" + id;
result = DBModel.ExecuteCustomQuery(query);
if (result == true)
{
query = "select EquipID from MachineGroupRelationTable where GroupID=" + id;
DataTable dt = new DataTable();
dt = DBModel.CustomSelectQuery(query);
if (dt != null)
{
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string EquipID = dr["EquipID"].ToString();
if (isEnabled == true)
{
MarkEquipmentAsGrouped(EquipID);
}
else
{
MarkEquipmentAsUngrouped(EquipID);
}
}
}
}
string[] computer_name = Dns.GetHostEntry(HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]).HostName.Split(new Char[] { '.' });
string HostName = computer_name[0].ToString().ToUpper();
string IP = HttpHandler.GetIPAddress();
AuditModel.AddLog("Group Settings", "Updated Equipment Group - ID: " + id, HostName, IP, HttpContext.Current.Session["Username"].ToString());
}
}
}
}
}
catch
{
result = false;
}
return(result);
}
//for saving config settings
public static bool SaveConfig(bool isSignalR, double tolerance, bool isOPCTimeout, double OPCTimeout, string DefaultPassword, string NoMarkTemplate, bool isScanner, bool isHost, bool isEffectiveDate)
{
bool result = false;
try
{
DataTable dt = new DataTable();
string query = "select isSignalR, Tolerance, isOPCTimeout, OPCTimeout, DefaultPassword, NoMarkTemplate, isScanner, isHostEnrollment from tblSettings";
dt = DBModel.CustomSelectQuery(query);
string bit = "";
if (isSignalR.ToString().ToLower() == "true")
{
bit = "1";
}
else
{
bit = "0";
}
string bit2 = "";
if (isOPCTimeout.ToString().ToLower() == "true")
{
bit2 = "1";
}
else
{
bit2 = "0";
}
string bit3 = "";
if (isScanner.ToString().ToLower() == "true")
{
bit3 = "1";
}
else
{
bit3 = "0";
}
string bit4 = "";
if (isHost.ToString().ToLower() == "true")
{
bit4 = "1";
}
else
{
bit4 = "0";
}
string bit5 = "";
if (isEffectiveDate.ToString().ToLower() == "true")
{
bit5 = "1";
}
else
{
bit5 = "0";
}
if (dt.Rows.Count > 0)
{
query = "update tblSettings set isSignalR=" + bit.ToString() + "," + "Tolerance=" + tolerance.ToString()
+ "," + "isOPCTimeout=" + bit2.ToString()
+ "," + "OPCTimeout=" + OPCTimeout.ToString()
+ "," + "isScanner=" + bit3.ToString()
+ "," + "isHostEnrollment=" + bit4.ToString()
+ "," + "IsEffectiveDate=" + bit5.ToString()
+ "," + "NoMarkTemplate='" + NoMarkTemplate.ToString().ToUpper() + "'"
+ "," + "DefaultPassword='******'";
}
else
{
query = "insert into tblSettings(isSignalR,Tolerance,isOPCTimeout,OPCTimeout,NoMarkTemplate,DefaultPassword,isScanner,isHostEnrollment,IsEffectiveDate) values(" + bit.ToString() + "," + tolerance.ToString()
+ "," + bit2.ToString()
+ "," + OPCTimeout.ToString()
+ "," + "'" + NoMarkTemplate.ToString().ToUpper() + "'"
+ "," + "'" + DefaultPassword.ToString() + "'"
+ "," + bit3.ToString()
+ "," + bit4.ToString()
+ "," + bit5.ToString()
+ ")";
}
result = DBModel.ExecuteCustomQuery(query);
if (result == true)
{
string[] computer_name = Dns.GetHostEntry(HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]).HostName.Split(new Char[] { '.' });
string HostName = computer_name[0].ToString().ToUpper();
string IP = HttpHandler.GetIPAddress();
AuditModel.AddLog("Configuration", "Updated Configuration", HostName, IP, HttpContext.Current.Session["Username"].ToString());
}
}
catch
{
result = false;
}
return(result);
}