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