public string AddMachineIdleTime(MachineIdle model)
{
string returnMessage = string.Empty;
try
{
using (var db = new DBContext())
{
if (ModelState.IsValid)
{
MachineDetail machineDetail = db.MachineDetails.Find(model.MachineDetailId);
if (machineDetail == null)
{
return("Invalid Machine Id");
}
db.MachineIdles.Add(model);
db.SaveChanges();
returnMessage = "OK";
}
}
}
catch (Exception e)
{
returnMessage = e.Message;
ExceptionHandler handler = new ExceptionHandler();
handler.HandleException(e);
}
return(returnMessage);
}
// GET: AttendanceController/Edit/5
public ActionResult Edit(int id)
{
if (getCurrentUser() == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
MachineDetail machine = ibio.GetMachine(id);
return(View(machine));
}
}
public string AddBrowserDetails(BrowserDetail model)
{
string returnMessage = string.Empty;
try
{
using (var db = new DBContext())
{
if (ModelState.IsValid)
{
MachineDetail machineDetail = db.MachineDetails.Find(model.MachineDetailId);
if (machineDetail == null)
{
return("Invalid Machine Id");
}
string domain = Utility.GetDomainPart(model.URL);
var subCategory = db.SubCategory.Where(a => a.SubCategoryName == domain && a.SubCategoryTypeId == 1).FirstOrDefault();
if (subCategory == null)
{
var uncaregorizedId = db.Category.Where(a => a.CategoryName.Trim() == "UnCategorized".Trim()).Select(a => a.CategoryId).FirstOrDefault();
subCategory = new SubCategory();
subCategory.CategoryId = Convert.ToInt32(uncaregorizedId);
subCategory.SubCategoryTypeId = 1;
subCategory.SubCategoryName = domain;
subCategory.IsProductive = false;
subCategory.IsBlocked = false;
subCategory.IsActive = true;
subCategory.CreatedDate = DateTime.Now;
subCategory.CreatedBy = 1;
db.SubCategory.Add(subCategory);
db.SaveChanges();
}
db.BrowserDetails.Add(model);
db.SaveChanges();
returnMessage = "OK";
}
}
}
catch (Exception e)
{
returnMessage = e.Message;
ExceptionHandler handler = new ExceptionHandler();
handler.HandleException(e);
}
return(returnMessage);
}
public string AddMachineDetails(MachineDetail model)
{
string machineId = string.Empty;
try
{
using (var db = new DBContext())
{
if (ModelState.IsValid)
{
MachineDetail machineDetail = db.MachineDetails.FirstOrDefault(m => m.MachineMacAddress.ToUpper() == model.MachineMacAddress.ToUpper() && m.UserName == model.UserName && m.CustomerId == model.CustomerId);
if (machineDetail == null)
{
db.MachineDetails.Add(model);
db.SaveChanges();
machineId = model.MachineDetailId.ToString() + "_" + model.IsBlocked;
// Adding record in AdminScheduleReport Table for sending Report to <ADMIN> only
AdminScheduleReport modl = new AdminScheduleReport();
modl.CustomerId = model.CustomerId;
modl.MachineDetailId = model.MachineDetailId;
modl.bSend = false;
db.AdminScheduleReport.Add(modl);
db.SaveChanges();
}
else
{
machineId = machineDetail.MachineDetailId.ToString() + "_" + machineDetail.IsBlocked;
// Adding record in AdminScheduleReport Table for sending Report to <ADMIN> only
AdminScheduleReport modl = new AdminScheduleReport();
modl.CustomerId = machineDetail.CustomerId;
modl.MachineDetailId = machineDetail.MachineDetailId;
modl.bSend = false;
db.AdminScheduleReport.Add(modl);
db.SaveChanges();
}
}
}
}
catch (Exception e)
{
ExceptionHandler handler = new ExceptionHandler();
handler.HandleException(e);
}
return(machineId);
}
public void InsertData(string macineKey)
{
try
{
IMyContractCallBack callback = OperationContext.Current.GetCallbackChannel<IMyContractCallBack>();
using (DuplexApp_dbEntities entities = new DuplexApp_dbEntities())
{
var data = entities.MachineDetails.Where(m => m.MachineKey == macineKey).FirstOrDefault();
if (data != null)
{
string clientAddress = data.ClientAddress;
lock (locker)
{
//remove the old client
if (clients.Keys.Contains(clientAddress.ToString()))
clients.Remove(clientAddress.ToString());
clients.Add(clientAddress.ToString(), callback);
}
}
else
{
string clientAddress = Guid.NewGuid().ToString();
//EndpointAddress clientAddress = OperationContext.Current.Channel.RemoteAddress;
lock (locker)
{
//remove the old client
if (clients.Keys.Contains(clientAddress.ToString()))
clients.Remove(clientAddress.ToString());
clients.Add(clientAddress.ToString(), callback);
}
MachineDetail tbl = new MachineDetail();
tbl.MachineKey = macineKey;
tbl.CreatedDate = System.DateTime.Now;
tbl.ClientAddress = clientAddress.ToString();
entities.MachineDetails.Add(tbl);
entities.SaveChanges();
}
}
}
catch (Exception ex)
{
log.Info(ex.Message.ToString());
}
}
public List <MachineDetail> GetMachineDetail(string id, string startDate, string endDate)
{
var format = "hh:mm tt";
var formatDate = "dddd, dd MMMM yyyy";
var start = new DateTime();
var end = new DateTime();
var model = new List <MachineDetail>();
var standard = _dbContext.setting.Where(x => x.id.Equals(id)).FirstOrDefault().standardRPM;
var sequenceList = _dbContext.rawdata.Where(x => x.machineID == id).Select(y => new { y.createddatetime, y.sequence }).ToList();
if (!startDate.IsNullOrEmpty() && !endDate.IsNullOrEmpty())
{
start = Convert.ToDateTime(startDate);
end = Convert.ToDateTime(endDate);
sequenceList = sequenceList.Where(x => x.createddatetime.Date >= start.Date && x.createddatetime.Date <= end.Date).ToList();
}
;
if (!startDate.IsNullOrEmpty())
{
start = Convert.ToDateTime(startDate);
sequenceList = sequenceList.Where(x => x.createddatetime.Date >= start.Date).ToList();
}
;
sequenceList = sequenceList.Where(x => x.createddatetime.Date == DateTime.Today.Date).ToList();
foreach (var item in sequenceList.Distinct())
{
var max = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item.sequence).Select(y => y.createddatetime).Max();
var min = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item.sequence).Select(y => y.createddatetime).Min();
var vm = new MachineDetail();
vm.MachineID = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item.sequence).Select(y => y.machineID).FirstOrDefault();
vm.StartTime = min.ToString(format);
vm.EndTime = max.ToString(format);
vm.RPM = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item.sequence).Select(y => y.RPM).Average();
vm.Date = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item.sequence).Select(y => y.createddatetime).Max().ToString(formatDate);
vm.Minutes = max.Subtract(min).Minutes;
vm.Status = standard < _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item.sequence).Select(y => y.RPM).Average();
model.Add(vm);
}
model = model.ToArray().Reverse().Take(15).ToList();
return(model);
}
static void Main(string[] args)
{
var factory =
new WebChannelFactory <IMachine>(new Uri("http://localhost:8080/RESTWcf"));
IMachine machine = factory.CreateChannel();
while (true)
{
Console.WriteLine("To submit press 1 \nTo delete press 2 \nto Retrive press 3\n\n");
string readLine = Console.ReadLine();
if (readLine.Equals("1"))
{
Console.WriteLine("please enter the machine name");
string machineName = Console.ReadLine();
var machineDetail = new MachineDetail {
Name = machineName
};
string addMachine = machine.AddMachine(machineDetail);
Console.WriteLine(addMachine);
}
else if (readLine.Equals("2"))
{
Console.WriteLine("please enter the machine Id that you want to delete");
string machineId = Console.ReadLine();
string deleteMachineById = machine.DeleteMachineById(machineId);
Console.WriteLine(deleteMachineById);
}
else if (readLine.Equals("3"))
{
Console.WriteLine("please enter the machine Id that you want to get");
string machineId = Console.ReadLine();
string machineNameById = machine.GetMachineNameById(machineId);
Console.WriteLine(machineNameById);
}
else
{
break;
}
}
}
public ActionResult Edit(int id, MachineDetail machine)
{
if (getCurrentUser() == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
var entity = context.MachineDetails.FirstOrDefault(item => item.machine_Id == id);
if (entity != null)
{
entity.machine_name = machine.machine_name;
entity.port_number = machine.port_number;
entity.ip_address = machine.ip_address;
context.SaveChanges();
}
return(RedirectToAction(nameof(MachineDetail)));
}
}
public object GetDetail(string id)
{
id = id.ToUpper();
var model = new List <MachineDetail>();
var sequenceList = _dbContext.rawdata.Where(x => x.machineID == id).Select(y => y.sequence).Distinct().ToList();
foreach (var item in sequenceList)
{
var vm = new MachineDetail();
vm.MachineID = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.machineID).FirstOrDefault();
vm.StartTime = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.createddatetime).Min().ToString("dddd, dd MMMM yyyy hh:mm tt");
vm.EndTime = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.createddatetime).Max().ToString("dddd, dd MMMM yyyy hh:mm tt");
vm.RPM = _dbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.RPM).Average();
model.Add(vm);
}
model = model.ToArray().Reverse().Take(15).ToList();
return(new
{
model,
standard = _dbContext.setting.Where(x => x.id.Equals(id)).FirstOrDefault()?.standardRPM
});
}
public ActionResult SetBlockUser(int MachineDetailId = 0, string Status = null)
{
MachineDetail MachineDetail = new MachineDetail();
try
{
if (ModelState.IsValid)
{
using (var db = new DBContext())
{
MachineDetail = db.MachineDetails.Where(a => a.MachineDetailId == MachineDetailId).FirstOrDefault();
if (MachineDetail == null)
{
return(HttpNotFound());
}
if (Status == "block")
{
MachineDetail.IsBlocked = true;
}
else
{
MachineDetail.IsBlocked = false;
}
db.Entry(MachineDetail).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
}
catch (Exception e)
{
ExceptionHandler handler = new ExceptionHandler();
handler.HandleException(e);
}
return(RedirectToAction("Index"));
}
public ActionResult Create(MachineDetail machine)
{
machine.created_at = DateTime.Now;
ibio.Add(machine);
return(RedirectToAction(nameof(MachineDetail)));
}
public MachineDetail GetMachine(int machine_Id)
{
MachineDetail machine = db.MachineDetails.Find(machine_Id);
return(machine);
}
public void Add(MachineDetail machine)
{
db.MachineDetails.Add(machine);
db.SaveChanges();
}
public List <MachineDetail> GetMachineDetail(string id, string startDate, string endDate)
{
var format = "hh:mm:ss tt";
var formatDate = "dddd, dd MMMM yyyy";
var start = new DateTime();
var end = new DateTime();
var model = new List <MachineDetail>();
var standard = _studentDbContext.setting.Where(x => x.id.Equals(id))
.FirstOrDefault().standardRPM;
var sequenceList = _studentDbContext.rawdata.Where(x => x.machineID == id)
.Select(y => new
{
y.createddatetime,
y.sequence
})
.ToList();
if (!startDate.IsNullOrEmpty() && !endDate.IsNullOrEmpty())
{
start = Convert.ToDateTime(startDate);
end = Convert.ToDateTime(endDate);
sequenceList = sequenceList.Where(x => x.createddatetime.Date >= start.Date && x.createddatetime.Date <= end.Date).ToList();
}
else if (!startDate.IsNullOrEmpty())
{
start = Convert.ToDateTime(startDate);
sequenceList = sequenceList.Where(x => x.createddatetime.Date >= start.Date).ToList();
}
else if (!endDate.IsNullOrEmpty())
{
end = Convert.ToDateTime(endDate);
sequenceList = sequenceList.Where(x => x.createddatetime.Date <= end.Date).ToList();
}
else
{
sequenceList = sequenceList.Where(x => x.createddatetime.Date == DateTime.Now.Date).ToList();
};
int count = 1;
foreach (var item in sequenceList.Select(x => x.sequence).Distinct())
{
var max = _studentDbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.createddatetime).Max();
var min = _studentDbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.createddatetime).Min();
var totalMinutes = Math.Round(TimeSpan.FromTicks(max.Ticks - min.Ticks).TotalMinutes, 2);
var totalSeconds = TimeSpan.FromTicks(max.Ticks - min.Ticks).TotalSeconds;
var vm = new MachineDetail();
vm.No = count;
vm.MachineID = _studentDbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.machineID).FirstOrDefault();
vm.StartTime = min.ToString(format);
vm.EndTime = max.ToString(format);
vm.RPM = _studentDbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.RPM).Average();
vm.Date = _studentDbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.createddatetime).Max().ToString(formatDate);
vm.Minutes = totalMinutes;
vm.Second = (int)totalSeconds;
vm.Status = standard < _studentDbContext.rawdata.Where(x => x.machineID.Equals(id) && x.sequence == item).Select(y => y.RPM).Average();
model.Add(vm);
count++;
}
model = model.ToArray().Reverse().Take(30).ToList();
return(model);
}
