/// <summary>
/// Saves the alarm messages
/// </summary>
/// <param name="ip">The ip.</param>
/// <param name="msg">The MSG.</param>
/// <param name="altime">The altime.</param>
/// <returns>System.Int32.</returns>
public int SaveMonitoringDetails(string ip, string msg, string altime)
{
int result = 0;
try
{
using (var context = new organisationdatabaseEntities())
{
var cid = context.classdetails.Where(x => x.camipS == ip || x.camipT == ip).Select(x => x.classID).FirstOrDefault();
var monitorobj = new alarmmonitorlog()
{
almMessage = msg,
almTime = Convert.ToDateTime(altime),
Classid = cid,
deviceip = ip
};
context.alarmmonitorlogs.Add(monitorobj);
result = context.SaveChanges();
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(result);
}
/// <summary>
/// Saves the power usage information.
/// </summary>
/// <param name="pow">The pow.</param>
/// <param name="mac">The mac.</param>
/// <param name="typ">The typ.</param>
/// <returns>System.Int32.</returns>
public int SavePowerUsageInfo(int pow, string mac, string typ)
{
int r = 0;
var found = false;
foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings)
{
if (!found)
{
if (c.Name.Contains("Entities"))
{
try
{
using (var context = new organisationdatabaseEntities(c.Name))
{
var cid = context.classdetails.Where(x => x.ccmac == mac)
.Select(x => x.classID).FirstOrDefault();
if (cid > 0)
{
found = true;
machineusagelogs_minute m = new machineusagelogs_minute()
{
classid = cid,
value = pow,
attribute = typ,
recordtime = DateTime.Now
};
context.machineusagelogs_minute.Add(m);
r = context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
else
{
break;
}
}
return(r);
}
/// <summary>
/// Updates the projector configuration.
/// </summary>
/// <param name="mac">The mac.</param>
/// <param name="val">The value.</param>
/// <returns>System.Int32.</returns>
public int UpdateProjectorConfig(string mac, string val)
{
int r = 0; string stat = "";
var found = false;
foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings)
{
if (!found)
{
if (c.Name.Contains("Entities"))
{
if (val == "True")
{
stat = "Registered";
}
else
{
stat = "Pending";
}
using (var context = new organisationdatabaseEntities(c.Name))
{
var classid = context.classdetails.Where(x => x.ccmac == mac).Select(x => x.classID).FirstOrDefault();
if (classid != 0)
{
found = true;
var d = context.projectorconfiginfoes.Where(x => x.Classid == classid).Select(x => x).FirstOrDefault();
if (d != null)
{
d.status = stat;
}
}
r = context.SaveChanges();
}
}
}
else
{
break;
}
}
return(r);
}
/// <summary>
/// Gets the power usage information.
/// </summary>
/// <param name="mac">The mac.</param>
/// <param name="typ">The typ.</param>
/// <returns>System.String.</returns>
public string GetPowerUsageInfo(string mac, string typ)
{
int r = 0;
var data = "";
var found = false;
foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings)
{
if (!found)
{
if (c.Name.Contains("Entities"))
{
try
{
using (var context = new organisationdatabaseEntities(c.Name))
{
var cid = context.classdetails.Where(x => x.ccmac == mac).OrderBy(x => x.classID)
.Select(x => x.classID).FirstOrDefault();
if (cid > 0)
{
found = true;
data = context.Database.ExecuteSqlCommand("SELECT sum(value) as " +
"value from organisationdatabase.machineusagelogs_minute WHERE " +
"date(recordtime)= date(now()) and attribute = 'Power'" +
" and classid =" + cid).ToString();
r = context.SaveChanges();
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
else
{
break;
}
}
return(data);
}
/// <summary>
/// Saves the reader log.
/// </summary>
/// <param name="message">The message.</param>
/// <param name="mac">The mac.</param>
/// <param name="cardid">The cardid.</param>
/// <returns>System.Int32.</returns>
public int SaveReaderLog(string message, string mac, string cardid)
{
int result = 0;
var found = false;
foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings)
{
if (!found)
{
if (c.Name.Contains("Entities"))
{
try
{
using (var context = new organisationdatabaseEntities(c.Name))
{
var classid = context.classdetails.Where(x => x.ccmac == mac).Select(x => x.classID).FirstOrDefault();
if (classid != 0)
{
found = true;
cardlog cardlog = new cardlog()
{
Message = message,
ClassId = classid,
cardId = cardid,
ActionTime = DateTime.Now
};
context.cardlogs.Add(cardlog);
result = context.SaveChanges();
}
}
}
catch (Exception)
{
}
}
}
else
{
break;
}
}
return(result);
}
/// <summary>
/// Updates the status of card reg.
/// </summary>
/// <param name="stat">The stat.</param>
/// <param name="mac">The mac.</param>
/// <param name="cid">The cid.</param>
/// <returns>System.Int32.</returns>
public int UpdateStatCardReg(string stat, string mac, string cid)
{
int result = 0;
var found = false;
foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings)
{
if (!found)
{
if (c.Name.Contains("Entities"))
{
using (var context = new organisationdatabaseEntities(c.Name))
{
var classid = context.classdetails.Where(x => x.ccmac == mac).Select(x => x.classID).FirstOrDefault();
if (context.card_registration.Any(x => x.calssId == classid && x.OneCardId == cid))
{
var row = context.card_registration.Where(x => x.calssId == classid && x.OneCardId == cid)
.Select(x => x).FirstOrDefault();
if (row != null)
{
found = true;
Console.WriteLine("status: " + row.Status);
row.Status = stat;
row.UpdateTime = DateTime.Now;
}
result = context.SaveChanges();
}
Console.WriteLine("UpdatedRows:" + result);
}
}
}
else
{
break;
}
}
return(result);
}
