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