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