public JsonResult addAddress(string _address, string _deviceType) { if (User.Identity.IsAuthenticated) { if (_address.Length > 0 && _deviceType.Length > 0) { List<WhoIsOnlineModel> addresses = new List<WhoIsOnlineModel>(); WhoIsOnlineModel s = new WhoIsOnlineModel(); addresses = s.getAddresses(); bool check = true; foreach (var item in addresses) { if (item.Address == _address) { check = false; } } if (check) { s.Address = _address; s.DeviceType = _deviceType; s.Owner = User.Identity.Name; s.CreateEntry(s); } return Json(true); } } return Json(false); }
public JsonResult deleteAddress(string id) { if (User.Identity.IsAuthenticated) { WhoIsOnlineModel s = new WhoIsOnlineModel(); s.deleteAddressById(Convert.ToInt32(id)); return Json(true); } return Json(false); }
public void CreateEntry(WhoIsOnlineModel s) { using (var cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename" + "=|DataDirectory|\\Database.mdf; Integrated Security=True")) { string _insertSql = @"INSERT INTO [dbo].[MacAddresses] ([DeviceOwner], [MacAddress], [TypeOfDevice]) VALUES (@DeviceOwner, @MacAddress, @TypeOfDevice)"; var insertCmd = new SqlCommand(_insertSql, cn); insertCmd.Parameters .Add(new SqlParameter("@DeviceOwner", SqlDbType.NVarChar)) .Value = s.Owner; insertCmd.Parameters .Add(new SqlParameter("@MacAddress", SqlDbType.NVarChar)) .Value = s.Address; insertCmd.Parameters .Add(new SqlParameter("@TypeOfDevice", SqlDbType.NVarChar)) .Value = s.DeviceType; cn.Open(); insertCmd.ExecuteNonQuery(); cn.Close(); } }
public List<WhoIsOnlineModel> getAddresses() { List<WhoIsOnlineModel> items = new List<WhoIsOnlineModel>(); using (var cn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename" + "=|DataDirectory|\\Database.mdf; Integrated Security=True")) { string _sql = @"SELECT * FROM [dbo].[MacAddresses]"; var cmd = new SqlCommand(_sql, cn); cn.Open(); var reader = cmd.ExecuteReader(); if (reader.HasRows) { try { while (reader.Read()) { WhoIsOnlineModel item = new WhoIsOnlineModel(); item.Id = Convert.ToInt32(reader["Id"].ToString()); item.Owner = reader["DeviceOwner"].ToString(); item.Address = reader["MacAddress"].ToString(); item.DeviceType = reader["TypeOfDevice"].ToString(); items.Add(item); } } catch (Exception e) { return items; } } reader.Dispose(); cmd.Dispose(); } return items; }