public async Task <IActionResult> Edit(int id, [Bind("sensorID,timestamp,humidity,CO2,temperature")] Models.Data data)
{
if (id != data.sensorID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(data);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DataExists(data.sensorID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["sensorID"] = new SelectList(_context.Set <Sensor>(), "sensorID", "sensorID", data.sensorID);
return(View(data));
}
protected void btnLogin_Click(object sender, EventArgs e)
{
Models.Chatter user = new Models.Chatter()
{
Email = txtEmailSI.Text.Trim(),
Password = txtPasswordSI.Text.Trim()
};
if (user.IsAuthenticated)
{
user = new Models.Data().Chatters.Where(x => x.Email == user.Email).First();
//FormsAuthentication.SetAuthCookie(user.Email, true);
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, user.Email, DateTime.UtcNow, DateTime.UtcNow.AddYears(1), true, user.ChatterId.ToString());
HttpCookie authCookie = new HttpCookie("ch_us_dt", FormsAuthentication.Encrypt(ticket));
HttpCookie idCookie = new HttpCookie("ch_us_id")
{
Value = user.ChatterId.ToString()
};
Response.Cookies.Add(authCookie);
Response.Cookies.Add(idCookie);
FormsAuthentication.RedirectFromLoginPage(user.Email, true);
}
else
{
loginErrror.Visible = true;
}
}
public async Task <IActionResult> Edit(string id, [Bind("Age,Attrition,BusinessTravel,DailyRate,Department,DistanceFromHome,Education,EducationField,EmployeeCount,EmployeeNumber,EnvironmentSatisfaction,Gender,HourlyRate,JobInvolvement,JobLevel,JobRole,JobSatisfaction,MaritalStatus,MonthlyIncome,MonthlyRate,NumCompaniesWorked,Over18,OverTime,PercentSalaryHike,PerformanceRating,RelationshipSatisfaction,StandardHours,StockOptionLevel,TotalWorkingYears,TrainingTimesLastYear,WorkLifeBalance,YearsAtCompany,YearsInCurrentRole,YearsSinceLastPromotion,YearsWithCurrManager")] Models.Data data)
{
if (id != data.EmployeeNumber)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(data);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DataExists(data.EmployeeNumber))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(data));
}
public async Task <IActionResult> PutData(int id, Models.Data data)
{
if (id != data.sensorID)
{
return(BadRequest());
}
_context.Entry(data).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!DataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult DeleteSave(int id)
{
Models.Data dt = new Models.Data();
dt.Id = id;
db.Delete(dt);
return(RedirectToAction("index"));
}
public async Task <IActionResult> GetStatOut([FromBody] Models.Data f)
{
if (ModelState.IsValid)
{
var baseApl = new MapperConfiguration(cfg =>
{
cfg.CreateMap <Models.Data, APZ2.BLL.Models.DataWeather>();
}).CreateMapper().Map <APZ2.BLL.Models.DataWeather>(f);
var baseApl2 = new MapperConfiguration(cfg =>
{
cfg.CreateMap <Models.Data, APZ2.DAL.Models.Measurement>();
}).CreateMapper().Map <APZ2.DAL.Models.Measurement>(f);
baseApl2.UserId = f.Id;
baseApl2.Date = DateTime.Now;
//_iserv.GetStats();
_iservmes.AddMeasurement(baseApl2);
var stats = _iservmes.GetMeasurements(f.Id).ToList();
string lang = _sharedLocalizer["Test"];
var res = _iservmes.GetRecomendations(baseApl, lang);
Result result = new Result();
result.Res = res;
result.Stat = stats;
var s = JsonConvert.SerializeObject(result);
return(new ObjectResult(s));
}
else
{
return(new EmptyResult());
}
}
public ActionResult Update(int id)
{
Models.Data dat = db.Find(id);
ViewBag.data = dat;
ViewBag.date = dat.BDate.ToString("yyyy-MM-dd");
return(View());
}
public ActionResult SaveResult(string formId, string data)
{
ViewBag.formId = formId;
ViewBag.data = data;
ViewBag.status = "";
Models.Data currentData = new Models.Data()
{
Id = Guid.NewGuid().ToString(),
FormId = formId,
Content = data,
FunctionalLocation = "FunctionalLocation",
Remarks = "Remarks",
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
ViewBag.status = "Object instantiated";
ChecklistManagement.DataHelper dataHelper = new DataHelper();
if (dataHelper.Create(currentData))
{
ViewBag.status = "Object created";
}
return(View());
}
public ActionResult DeleteConfirmed(int id)
{
Models.Data data = db.Data.Find(id);
db.Data.Remove(data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: Acceso
public ActionResult Login(string User, string Pass)
{
Variables ob = new Variables();
try
{
using (Models.Data db = new Models.Data())
{
var oUser = (from d in db.Usuario
where d.Nickusuario == User.Trim() && d.Contra == Pass.Trim()
select d).FirstOrDefault();
if (oUser == null)
{
ViewBag.Error = "Usuario o contraseña incorrecta";
return(View());
}
Session["User"] = oUser;
}
return(RedirectToAction("Index", "Home"));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
return(View());
}
}
public async void Can_post_items()
{
using (_context)
{
DataController controller = new DataController(_context);
SensorsController sensorsController = new SensorsController(_context);
// Finding a sensor to atach the data
var sensors = sensorsController.GetSensor();
var List = new List <Sensor>();
var sensorID = 0;
foreach (var data1 in sensors.Result.Value.ToList())
{
List.Add(data1);
}
if (List.Count > 0)
{
var item = List[List.Count - 1];
sensorID = item.sensorID;
}
Models.Data testdata = new Models.Data();
testdata.sensorID = sensorID;
testdata.timestamp = DateTime.Today;
testdata.humidity = 123;
testdata.CO2 = 123;
testdata.temperature = 123;
await controller.PostData(testdata);
var data = controller.GetData();
var DTOList = new List <DataDTO>();
int DTOListcount = 0;
foreach (var data1 in data.Result.Value.ToList())
{
DTOList.Add(data1);
DTOListcount++;
}
Assert.AreEqual(DTOListcount, DTOList.Count);
Assert.AreEqual("123", DTOList[DTOList.Count - 1].CO2_value.ToString());
//Delete
await controller.DeleteData(sensorID, DateTime.Today);
data = controller.GetData();
DTOList = new List <DataDTO>();
foreach (var data1 in data.Result.Value.ToList())
{
DTOList.Add(data1);
}
Assert.AreEqual(DTOListcount - 1, DTOList.Count);
}
}
private void SaveUrl <T>(T item, Models.Data data) where T : DataItem
{
if (IsExists(item, data))
{
return;
}
data.Urls.Add(item as Url);
}
public ActionResult Edit([Bind(Include = "Id,First,Last,Email,Subject,Msg")] Models.Data data)
{
if (ModelState.IsValid)
{
db.Entry(data).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(data));
}
public void Save(Models.Data data)
{
Sensor sensor = GetMatchingSensor(data, _context);
data.sensorID = sensor.sensorID;
_context.Add(data);
_context.SaveChanges();
Console.WriteLine("Added data to DB.\n");
SendMessage(sensor);
Console.WriteLine("Message Sent\n");
}
public void ConverterTest()
{
string hex = "0029001502e5";
LoriotWebsocket lws = new LoriotWebsocket(new DataWebserviceContext());
Models.Data data = lws.HexIntoData(hex);
Assert.IsTrue(data.humidity == 41);
Assert.IsTrue(data.CO2 == 21);
Assert.IsTrue(data.temperature == 741);
}
public ActionResult contact(Models.Data data)
{
if (ModelState.IsValid)
{
db.Data.Add(data);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(data));
}
public static void ReadCallback(IAsyncResult ar)
{
String content = String.Empty;
// Retrieve the state object and the handler socket
// from the asynchronous state object.
StateObject state = (StateObject)ar.AsyncState;
Socket handler = state.workSocket;
MemoryStream memoryStream = new MemoryStream();
// Read data from the client socket.
int bytesRead = handler.EndReceive(ar);
while (bytesRead > 0)
{
memoryStream.Write(state.buffer, 0, bytesRead);
if (handler.Available > 0)
{
bytesRead = handler.EndReceive(ar);
}
else
{
break;
}
}
if (memoryStream.Length > 0)
{
state.sb.Append(Encoding.ASCII.GetString(
state.buffer, 0, bytesRead));
content = state.sb.ToString();
var match = Regex.Match(content, @"\{(.|\s)*\}");
var json = match.Value;
Models.Data _data = JsonConvert.DeserializeObject <Models.Data>(json);
DataSingleton.SetInstance(_data);
MainActivity.SetDataToControls();
memoryStream.Close();
//Echo the data back to the client.
Send(handler, content);
}
else
{
// Not all data received. Get more.
handler.BeginReceive(state.buffer, 0, StateObject.BufferSize, 0,
new AsyncCallback(ReadCallback), state);
}
}
private static void PrepareDisabledMovement(List <Edge> edges, Models.Data data, List <DisabledMovement> dm)
{
DisabledMovement = new Dictionary <Node, List <DisabledMovement> >();
foreach (var d in dm)
{
if (!DisabledMovement.Keys.Contains(d.StartEdgeNavigation.EndNodeNavigation))
{
DisabledMovement.Add(d.StartEdgeNavigation.EndNodeNavigation, new List <DisabledMovement>());
}
DisabledMovement[d.StartEdgeNavigation.EndNodeNavigation].Add(d);
}
}
public async Task <IActionResult> Create([Bind("sensorID,timestamp,humidity,CO2,temperature")] Models.Data data)
{
if (ModelState.IsValid)
{
_context.Add(data);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["sensorID"] = new SelectList(_context.Set <Sensor>(), "sensorID", "sensorID", data.sensorID);
return(View(data));
}
// GET: Home/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Models.Data data = db.Data.Find(id);
if (data == null)
{
return(HttpNotFound());
}
return(View(data));
}
public async Task <IActionResult> Calculator()
{
if (User.IsInRole("User"))
{
var t = new Models.Data();
return(View(t));
}
else
{
return(RedirectToAction("Login", "Account"));
}
}
public static DataDto MapDataToDto(Models.Data data)
{
var dataDto = new DataDto
{
Latitude = data.Latitude,
Longitude = data.Longitude,
Time = data.Time,
Line = data.Line,
Brigade = data.Brigade
};
return(dataDto);
}
public Models.Data HexIntoData(String hex)
{
Models.Data data = new Models.Data();
string[] dataArray = new string[3];
for (int i = 0; i < 3; i++)
{
dataArray[i] = hex.Substring(i * 4, 4);
}
data.humidity = Convert.ToInt32(dataArray[0], 16);
data.temperature = Convert.ToInt32(dataArray[1], 16);
data.CO2 = Convert.ToInt32(dataArray[2], 16);
return(data);
}
public ActionResult Test(string activity, string dataid)
{
if (activity != null)
{
Models.Data testData = new Models.Data()
{
Id = Guid.NewGuid().ToString(),
FormId = Guid.NewGuid().ToString(),
Content = "test content",
FunctionalLocation = "test functional location",
Remarks = "rest remarks",
Version = 1,
Sequence = 1,
CreatedDate = DateTime.Now,
ModifiedDate = DateTime.Now
};
DataHelper helper = new DataHelper();
activity = activity.ToLower();
ViewBag.Action = activity;
switch (activity)
{
case "create":
ViewBag.ActionResult = helper.Create(testData);
return(View());
case "update":
ViewBag.ActionResult = helper.Update(testData);
return(View());
case "delete":
ViewBag.ActionResult = helper.Delete(dataid);
return(View());
case "retrieve":
List <Models.Data> resultList = helper.Retrieve(dataid);
return(View(resultList));
default:
return(View());
}
}
return(View());
}
public Sensor GetMatchingSensor(Models.Data data, DataWebserviceContext context)
{
Sensor sense = context.Sensor.AsQueryable().FirstOrDefault(s => s.sensorEUID == data.sensorEUID);
if (sense == null)
{
sense = new Sensor();
sense.sensorEUID = data.sensorEUID;
int count = context.Sensor.AsQueryable().Count();
sense.sensorLog = new List <SensorLog>();
sense.servoSetting = "00000000";
sc.PostSensor(sense).Wait();
sense = context.Sensor.AsQueryable().FirstOrDefault(s => s.sensorEUID == data.sensorEUID);
}
return(sense);
}
public async Task <IActionResult> GetStat(Models.Data f)
{
if (ModelState.IsValid)
{
var baseApl = new MapperConfiguration(cfg =>
{
cfg.CreateMap <Models.Data, APZ2.BLL.Models.DataWeather>();
}).CreateMapper().Map <APZ2.BLL.Models.DataWeather>(f);
var baseApl2 = new MapperConfiguration(cfg =>
{
cfg.CreateMap <Models.Data, APZ2.DAL.Models.Measurement>();
}).CreateMapper().Map <APZ2.DAL.Models.Measurement>(f);
baseApl2.UserId = _userManager.GetUserId(User);
baseApl2.Date = DateTime.Now;
//_iserv.GetStats();
_iservmes.AddMeasurement(baseApl2);
var stats = _iservmes.GetMeasurements(_userManager.GetUserId(User)).ToList();
var finstats = new List <Measurement>();
int i = 0;
foreach (var v in stats)
{
if (i >= 15)
{
break;
}
finstats.Add(v);
i++;
}
string lang = _sharedLocalizer["Test"];
var res = _iservmes.GetRecomendations(baseApl, lang);
res[1] = "/Content/img/season" + res[1] + ".jpg";
Result result = new Result();
result.Res = res;
result.Stat = finstats;
return(PartialView(result));
}
else
{
return(new EmptyResult());
}
}
public void setupMessageRecieve(WebsocketClient client)
{
client.MessageReceived.Subscribe(json =>
{
Console.WriteLine("Message recieved.\n");
LoriotDTO loraData = JsonConvert.DeserializeObject <LoriotDTO>(json.ToString());
if (loraData.cmd == "rx")
{
Models.Data data = HexIntoData(loraData.data); //LoraData.data is a hex string, data is the webservices data class.
data.timestamp = new DateTime(1970, 1, 1, 2, 0, 0, DateTimeKind.Local).AddSeconds((double)loraData.ts / 1000); //Could be improved.
Console.WriteLine("Date is: " + data.timestamp + "\n");
data.sensorEUID = loraData.EUI;
Task.Run(() => Save(data));
}
else
{
Console.WriteLine("Command was not rx");
}
});
}
public async Task <ActionResult <Models.Data> > PostData(Models.Data data)
{
_context.Data.Add(data);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (DataExists(data.sensorID))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtAction("GetData", new { id = data.sensorID }, data));
}
public void RemoveData(Models.Data data)
{
Schema.Data.ScopedDatas.Remove(data);
}
public IActionResult RedirectToWithBody([FromBody] Models.Data data)
{
return(Ok(data));
}
