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); }