/// <summary>
/// Method to get user detail by user id
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public UsersModel GetUserModelList(int userId)
{
ServiceData serviceData = new ServiceData();
try
{
UsersModel lstUser;
using (DBUsers objDbUser = new DBUsers())
{
lstUser = objDbUser.GetUserModelList(userId);
}
return lstUser;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to update user detail
/// </summary>
/// <param name="userMl"></param>
/// <returns></returns>
public int UpdateUserDetails(UsersModel userMl)
{
ServiceData serviceData = new ServiceData();
try
{
int result;
using (DBUsers objDbUsers = new DBUsers())
{
result = objDbUsers.UpdateUserDetails(userMl);
}
return result;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Get device by logical device Id
/// </summary>
/// <param name="deviceMl"></param>
/// <returns></returns>
public int GetDeviceModelByLogicalDeviceId(DeviceModel deviceMl)
{
ServiceData serviceData = new ServiceData();
try
{
int result;
using (DBDevice objDbDevice = new DBDevice())
{
result = objDbDevice.GetDeviceModelByLogicalDeviceId(deviceMl);
}
return result;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get the device detail by logical device id
/// </summary>
/// <param name="logicalDeviceId"></param>
/// <returns></returns>
public DeviceModel GetDeviceByLogicalDeviceId(string logicalDeviceId)
{
ServiceData serviceData = new ServiceData();
try
{
DeviceModel lstDevice;
using (DBDevice objDbDevice = new DBDevice())
{
lstDevice = objDbDevice.GetDeviceByLogicalDeviceId(logicalDeviceId, Convert.ToInt32(ConfigurationManager.AppSettings["SensorTimeWindow"]));
}
return lstDevice;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method tot delete the device
/// </summary>
/// <param name="deviceId"></param>
/// <returns></returns>
public void DeleteDevice(int deviceId)
{
ServiceData serviceData = new ServiceData();
try
{
using (DBDevice objDbDevice = new DBDevice())
{
objDbDevice.DeleteDevice(deviceId);
}
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get the user be email id
/// </summary>
/// <param name="emailId"></param>
/// <returns></returns>
public UsersModel GetUserModelListByEmail(string emailId)
{
ServiceData serviceData = new ServiceData();
try
{
UsersModel objUser;
using (DBUsers objDbUsers = new DBUsers())
{
objUser = objDbUsers.GetUserModelListByEmail(emailId);
}
return objUser;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get list of temperatures
/// </summary>
/// <returns></returns>
public IEnumerable<TemperatureModel> GetTemperatureList(string logicalDeviceId, string readingTimeFrom, string readingTimeTo)
{
ServiceData serviceData = new ServiceData();
try
{
IEnumerable<TemperatureModel> lstTemperature;
using (DBTemperature objDbTemperature = new DBTemperature())
{
lstTemperature = objDbTemperature.GetTemperatureList(logicalDeviceId, readingTimeFrom, readingTimeTo);
}
return lstTemperature;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Get device by id for deletion
/// </summary>
/// <param name="deviceId"></param>
/// <returns></returns>
public DeviceModel GetDeviceById(int deviceId)
{
ServiceData serviceData = new ServiceData();
try
{
DeviceModel device;
using (DBDevice objDbDevice = new DBDevice())
{
device = objDbDevice.GetDeviceById(deviceId);
}
return device;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// MEthod to get the list of all items
/// </summary>
/// <returns></returns>
public IEnumerable<ItemModel> GetItemList()
{
ServiceData serviceData = new ServiceData();
try
{
IEnumerable<ItemModel> lstItem;
using (DBItem objDbItem = new DBItem())
{
lstItem = objDbItem.GetItemList();
}
return lstItem;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get item detail by item id
/// </summary>
/// <param name="itemId"></param>
/// <returns></returns>
public void DeleteItem(int itemId)
{
ServiceData serviceData = new ServiceData();
try
{
using (DBItem objDbItem = new DBItem())
{
objDbItem.DeleteItem(itemId);
}
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get Item by Item Id
/// </summary>
/// <param name="itemId"></param>
/// <returns></returns>
public ItemModel GetItemByItemId(int itemId)
{
ServiceData serviceData = new ServiceData();
try
{
ItemModel lstItem;
using (DBItem objDbItem = new DBItem())
{
lstItem = objDbItem.GetItemByItemId(itemId);
}
return lstItem;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get the list of inventories
/// </summary>
/// <returns></returns>
public IEnumerable<InventoryModel> GetInventoryList(string logicalDeviceId, string searchText)
{
ServiceData serviceData = new ServiceData();
try
{
IEnumerable<InventoryModel> lstInventory;
using (DBInventory objDbInventory = new DBInventory())
{
lstInventory = objDbInventory.GetInventoryList(logicalDeviceId, searchText);
}
return lstInventory;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to filter the user list by search text
/// </summary>
/// <param name="searchText"></param>
/// <returns></returns>
public List<UsersModel> GetFilterUserModelList(string searchText)
{
ServiceData serviceData = new ServiceData();
try
{
List<UsersModel> lstUsersModel;
using (DBUsers objDbUser = new DBUsers())
{
lstUsersModel = objDbUser.GetFilterUserModelList(searchText);
}
return lstUsersModel;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// search user by search text for server side searching and paging
/// </summary>
/// <param name="searchText"></param>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public List<UsersModel> SearchUserList(string searchText, int pageNumber, int pageSize)
{
ServiceData serviceData = new ServiceData();
try
{
List<UsersModel> lstUsersModel;
using (DBUsers objDbUser = new DBUsers())
{
lstUsersModel = objDbUser.SearchUserList(searchText, pageNumber, pageSize);
}
return lstUsersModel;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get device by deviceid with page number and page size for server side paging
/// </summary>
/// <param name="logicalDeviceId"></param>
/// <returns></returns>
public DeviceModel GetDeviceInventoriesList(string logicalDeviceId)
{
ServiceData serviceData = new ServiceData();
try
{
DeviceModel lstDevice;
using (DBDevice objDbDevice = new DBDevice())
{
lstDevice = objDbDevice.GetDeviceInventoriesList(logicalDeviceId);
}
return lstDevice;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to check duplicate device with serial number
/// </summary>
/// <param name="deviceId"></param>
/// <param name="serial"></param>
/// <returns></returns>
public int CheckForDuplicateSerial(int deviceId, string serial)
{
ServiceData serviceData = new ServiceData();
try
{
int result;
using (DBDevice objDbDevice = new DBDevice())
{
result = objDbDevice.CheckForDuplicateSerial(deviceId, serial);
}
return result;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Get ITem with EPC tag
/// </summary>
/// <param name="itemMl"></param>
/// <returns></returns>
public int GetItemModelByEpc(ItemModel itemMl)
{
ServiceData serviceData = new ServiceData();
try
{
int result;
using (DBItem objDbItem = new DBItem())
{
result = objDbItem.GetItemModelByEpc(itemMl);
}
return result;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get device list after applying filter of search text
/// </summary>
/// <param name="searchText"></param>
/// <returns></returns>
public List<DeviceModel> GetFilterDeviceList(string searchText)
{
ServiceData serviceData = new ServiceData();
try
{
List<DeviceModel> lstDevice;
using (DBDevice objDbDevice = new DBDevice())
{
lstDevice = objDbDevice.GetFilterDeviceList(searchText, Convert.ToInt32(ConfigurationManager.AppSettings["SensorTimeWindow"]));
}
return lstDevice;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get the itm list by search text filter
/// </summary>
/// <param name="searchText"></param>
/// <returns></returns>
public List<ItemModel> GetFilterItemList(string searchText)
{
ServiceData serviceData = new ServiceData();
try
{
List<ItemModel> lstItem;
using (DBItem objDbItem = new DBItem())
{
lstItem = objDbItem.GetFilterItemList(searchText);
}
return lstItem;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to get list of temperatures
/// </summary>
/// <param name="searchString"></param>
/// <param name="startDateFrom"></param>
/// <param name="startDateTo"></param>
/// <returns></returns>
public IEnumerable<TransactionModel> GetInventoryTransaction(string searchString, string startDateFrom, string startDateTo)
{
ServiceData serviceData = new ServiceData();
try
{
IEnumerable<TransactionModel> lstTransaction;
using (DBTransaction objDbTransaction = new DBTransaction())
{
lstTransaction = objDbTransaction.GetInventoryTransaction(searchString, startDateFrom, startDateTo, Convert.ToInt32(ConfigurationManager.AppSettings["SensorTimeWindow"]));
}
return lstTransaction;
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}
/// <summary>
/// Method to delete the user by user id
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public void DeleteUserDetails(int userId)
{
ServiceData serviceData = new ServiceData();
try
{
using (DBUsers objDbUsers = new DBUsers())
{
objDbUsers.DeleteUserDetails(userId);
}
}
catch (Exception ex)
{
serviceData.Result = false;
serviceData.ErrorMessage = ex.Message;
serviceData.ErrorDetails = ex.ToString();
throw new FaultException<ServiceData>(serviceData);
}
}