public ActionResult Devices(string filter, string value) { if (filter == "Issue") { AD_UserEquipmentsBL ueb = new AD_UserEquipmentsBL(); //var rec = ueb.SelectedList("ReturnedDevice", value, null); var rec = ueb.SelectedList("AvailableDevices", value, null); return(Json(rec, JsonRequestBehavior.AllowGet)); } else if (filter == "Transfer") { AD_UserEquipmentsBL ueb = new AD_UserEquipmentsBL(); var rec = ueb.SelectedList("IssuedDevice", value, null); return(Json(rec, JsonRequestBehavior.AllowGet)); } else if (filter == "Return") { Sec_UserDevicesBL udb = new Sec_UserDevicesBL(); var rec = udb.SelectedList("byUserId", value, null, "Devices"); return(Json(rec, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult byUser(int id = 0) { ViewBag.UserId = id; Sec_UserDevicesBL udbl = new Sec_UserDevicesBL(); var rec = udbl.ToList("byUserId", id.ToString()); return(PartialView("~/views/UserDevice/_byUser.cshtml", rec)); }
public ActionResult Edit(int id = 0) { Sec_UserDevicesBL udbl = new Sec_UserDevicesBL(); var rec = udbl.Single("byUserId", id.ToString()); if (rec.DeviceId > 0) { ViewBag.UserId = rec.UserId; } return(PartialView("~/views/UserDevice/_new.cshtml", rec)); }
public string Delete(int id = 0) { try { Sec_UserDevicesBL udbl = new Sec_UserDevicesBL(); Sec_UserDevices dev = new Sec_UserDevices(); dev.DeviceId = id; var rec = udbl.Manage("Delete", dev); return(rec.ToString()); } catch (Exception ex) { return(ex.Message); } }
public string Active(int DeviceId, bool Status) { try { Sec_UserDevicesBL udbl = new Sec_UserDevicesBL(); Sec_UserDevices dev = new Sec_UserDevices(); dev.DeviceId = DeviceId; dev.IsActive = Status; var rec = udbl.Manage("UpdateStatus", dev); return(rec.ToString()); } catch (Exception ex) { return(ex.Message); } }
public ActionResult SelectableList(string filter, string value) { if (filter == "DevicesUsers") { Sec_UserDevicesBL udb = new Sec_UserDevicesBL(); var rec = udb.SelectedList("All", ""); return(Json(rec, JsonRequestBehavior.AllowGet)); } else if (filter == "All") { Sec_UserBL ub = new Sec_UserBL(); var rec = ub.SelectedList("ByStatus", true.ToString()); return(Json(rec, JsonRequestBehavior.AllowGet)); } return(null); }
public List <SelectListItem> UserDevices(Int64 Id) { List <SelectListItem> items = new List <SelectListItem>(); Sec_UserDevicesBL udbl = new Sec_UserDevicesBL(); var lst = udbl.ToList("byUserId", Id.ToString()).Where(m => m.IsActive == true).ToList(); if (lst.Count > 1) { items.Add(new SelectListItem { Text = "All", Value = "0" }); } foreach (var item in lst) { items.Add(new SelectListItem { Text = item.Manufacturer + " " + item.Model + " [" + item.IMEI + "]", Value = item.DeviceId.ToString() }); } return(items); }
public bool SaveDevices(int SiteId, int TesterId, string Date, int[] NetworkMode, int[] Band, int[] Carrier, int[] Devices, int[] TesterIds) { try { string Queries = ""; int TempTesterId = 0; Sec_UserDevicesBL udbl = new Sec_UserDevicesBL(); var UserDevices = udbl.ToList("byUserId", TesterId.ToString()); for (int i = 0; i < NetworkMode.Length; i++) { if (Devices[i] == 0) { foreach (var item in UserDevices) { Queries = Queries + "INSERT INTO [dbo].[AV_WoDevices]([BandId],[CarrierId],[NetworkId],[UserId],[UserDeviceId],[SiteId])VALUES(" + Band[i] + ", " + Carrier[i] + "," + NetworkMode[i] + ", " + TesterId + ", " + item.DeviceId + ", " + SiteId + ");"; } } else { if (TesterIds != null) { TempTesterId = TesterIds[i]; } else { TempTesterId = TesterId; } // wodl.Manage(0, Band[i], Carrier[i], false, NetworkMode[i], TesterId, Devices[i], SiteId, 0, null); Queries = Queries + "INSERT INTO [dbo].[AV_WoDevices]([BandId],[CarrierId],[NetworkId],[UserId],[UserDeviceId],[SiteId])VALUES(" + Band[i] + ", " + Carrier[i] + "," + NetworkMode[i] + ", " + TesterId + ", " + Devices[i] + ", " + SiteId + ");"; } } DataContext.SqlQuery(Queries); return(true); } catch (Exception) { throw; } }
public string New(string[] DeviceId, int UserId, string[] Manufacturer, string[] Model, string[] IMEI, string[] MAC) { try { Sec_UserDevicesBL udb = new Sec_UserDevicesBL(); Sec_UserDevices dev; for (int i = 0; i < Manufacturer.Length; i++) { dev = new Sec_UserDevices(); if (!string.IsNullOrEmpty(DeviceId[i])) { dev.DeviceId = int.Parse(DeviceId[i]); } dev.UserId = UserId; dev.Manufacturer = Manufacturer[i]; dev.Model = Model[i]; dev.IMEI = IMEI[i]; dev.MAC = MAC[i]; if (dev.DeviceId > 0) { udb.Manage("Update", dev); } else if (udb.Manage("Insert", dev)) { // TempData["msg_success"] = "success"; } } return(null); } catch (Exception ex) { // TempData["msg_error"] = ex.Message; return(ex.Message); } }