public List<tblClientSiteDevice> GetAllClientSiteDevice(int ClientID, int pageNumber, int pageSize, int sortColumnIndex, string sortOrder, string searchText, ref int totalRecords)
{
List<tblClientSiteDevice> lstAllClientSiteDevice = new List<tblClientSiteDevice>();
int errNum = 0;
string errDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@ClientID", ParameterDirection.Input, 16, MySqlDbType.Int32, ClientID);
DataAccess.addSqlParam("@pageNumber", ParameterDirection.Input, 16, MySqlDbType.Int32, pageNumber);
DataAccess.addSqlParam("@pageRecord", ParameterDirection.Input, 16, MySqlDbType.Int32, pageSize);
DataAccess.addSqlParam("@sortColumnIndex", ParameterDirection.Input, 16, MySqlDbType.Int32, sortColumnIndex);
DataAccess.addSqlParam("@searchOrder", ParameterDirection.Input, 4, MySqlDbType.VarChar, sortOrder);
DataAccess.addSqlParam("@searchText", ParameterDirection.Input, 100, MySqlDbType.VarChar, searchText);
DataSet ds = DataAccess.ExecuteDataSet(GET_ALL_CLIENT_SITE_DEVICE, ref errNum, ref errDesc);
tblClientSiteDevice ClientsiteDevice = new tblClientSiteDevice();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dtClientsiteDevice = ds.Tables[0];
DataTable dtTotalRecords = ds.Tables[1];
totalRecords = Common.ConvertToInt(dtTotalRecords.Rows[0], "TotalRecords");
if (dtClientsiteDevice != null && dtClientsiteDevice.Rows.Count > 0)
{
for (int i = 0; i < dtClientsiteDevice.Rows.Count; i++)
{
DataRow dr = dtClientsiteDevice.Rows[i];
ClientsiteDevice = new tblClientSiteDevice();
ClientsiteDevice.DeviceID = Common.ConvertToInt(dr, "ClientSiteDeviceID");
ClientsiteDevice.ClientID = Common.ConvertToInt(dr, "ClientID");
ClientsiteDevice.DeviceType = new DeviceType();
ClientsiteDevice.DeviceType.ID = Common.ConvertToInt(dr, "DeviceType");
ClientsiteDevice.DeviceType.Name = LookUpValue.GetDeviceType(ClientsiteDevice.DeviceType.ID.Value);
ClientsiteDevice.DeviceIDFromRMMTool = Common.ConvertToString(dr, "DeviceIDFromRMMTool");
ClientsiteDevice.DeviceDescription = Common.ConvertToString(dr, "Description");
ClientsiteDevice.UserName = Common.ConvertToString(dr, "UserName");
ClientsiteDevice.Password = Common.ConvertToString(dr, "Password");
ClientsiteDevice.MiscInfo = Common.ConvertToString(dr, "MiscInfo");
ClientsiteDevice.IsAccessPolicy = new PolicyType();
ClientsiteDevice.IsAccessPolicy.Name = Common.ConvertToString(dr, "AccessPolicyName");
ClientsiteDevice.IsMaintenancePolicy = new PolicyType();
ClientsiteDevice.IsMaintenancePolicy.Name = Common.ConvertToString(dr, "MaintenancePolicyName");
ClientsiteDevice.IsPatchingPolicy = new PolicyType();
ClientsiteDevice.IsPatchingPolicy.Name = Common.ConvertToString(dr, "PatchingPolicyName");
ClientsiteDevice.IsAntiVirus = new PolicyType();
ClientsiteDevice.IsAntiVirus.Name = Common.ConvertToString(dr, "AVPolicy");
ClientsiteDevice.IsRMMTool = new PolicyType();
ClientsiteDevice.IsRMMTool.Name = Common.ConvertToString(dr, "ToolInfomationName");
ClientsiteDevice.IsBackUpPolicy = new PolicyType();
ClientsiteDevice.IsBackUpPolicy.Name = Common.ConvertToString(dr, "BackupPolicyName");
lstAllClientSiteDevice.Add(ClientsiteDevice);
}
}
}
return lstAllClientSiteDevice;
}
public JsonResult Device(tblClientSiteDevice model)
{
try
{
BLClientSiteDevice clientSiteDeviceBL = new BLClientSiteDevice();
model.CustomerID = SessionHelper.UserSession.CustomerID;
clientSiteDeviceBL.SaveClientSiteDevice(model);
}
catch
{
ModelState.AddModelError("", "Error occurred while saving device information.");
return Json(new { errors = KeyValue.GetErrorsFromModelState(ViewData) });
}
return Json(new { success = true, ClientID = model.ClientID });
}
public tblClientSiteDevice GetClientSiteDevice(int ClientSiteDeviceID, int CustomerID)
{
int errNum = 0;
string errDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@ClientSiteDeviceID", ParameterDirection.Input, 16, MySqlDbType.Int32, ClientSiteDeviceID);
DataAccess.addSqlParam("@CustomerID", ParameterDirection.Input, 16, MySqlDbType.Int32, CustomerID);
DataSet ds = DataAccess.ExecuteDataSet(GET_CLIENT_SITE_DEVICE, ref errNum, ref errDesc);
tblClientSiteDevice ClientsiteDevice = new tblClientSiteDevice();
if (ds != null && ds.Tables.Count > 0)
{
DataTable dtClientsiteDevice = ds.Tables[0];
if (dtClientsiteDevice != null && dtClientsiteDevice.Rows.Count > 0)
{
DataRow dr = dtClientsiteDevice.Rows[0];
ClientsiteDevice.DeviceID = Common.ConvertToInt(dr, "ClientSiteDeviceID");
ClientsiteDevice.ClientID = Common.ConvertToInt(dr, "ClientID");
ClientsiteDevice.DeviceType = new DeviceType();
ClientsiteDevice.DeviceType.ID = Common.ConvertToInt(dr, "DeviceType");
ClientsiteDevice.DeviceType.Name = LookUpValue.GetDeviceType(ClientsiteDevice.DeviceType.ID.Value);
ClientsiteDevice.DeviceIDFromRMMTool = Common.ConvertToString(dr, "DeviceIDFromRMMTool");
ClientsiteDevice.DeviceDescription = Common.ConvertToString(dr, "Description");
ClientsiteDevice.UserName = Common.ConvertToString(dr, "UserName");
ClientsiteDevice.Password = Common.ConvertToString(dr, "Password");
ClientsiteDevice.MiscInfo = Common.ConvertToString(dr, "MiscInfo");
ClientsiteDevice.IsAccessPolicy = new PolicyType();
ClientsiteDevice.IsAccessPolicy.ID = Common.ConvertToInt(dr, "PolicyID");
ClientsiteDevice.IsAccessPolicy.Name = LookUpValue.GetOptionType(ClientsiteDevice.IsAccessPolicy.ID.Value);
ClientsiteDevice.IsMaintenancePolicy = new PolicyType();
ClientsiteDevice.IsMaintenancePolicy.ID = Common.ConvertToInt(dr, "MaintenancePolicyID");
ClientsiteDevice.IsMaintenancePolicy.Name = LookUpValue.GetOptionType(ClientsiteDevice.IsMaintenancePolicy.ID.Value);
ClientsiteDevice.IsPatchingPolicy = new PolicyType();
ClientsiteDevice.IsPatchingPolicy.ID = Common.ConvertToInt(dr, "PatchingPolicyID");
ClientsiteDevice.IsPatchingPolicy.Name = LookUpValue.GetOptionType(ClientsiteDevice.IsPatchingPolicy.ID.Value);
ClientsiteDevice.IsAntiVirus = new PolicyType();
ClientsiteDevice.IsAntiVirus.ID = Common.ConvertToInt(dr, "AntiVirusID");
ClientsiteDevice.IsAntiVirus.Name = LookUpValue.GetOptionType(ClientsiteDevice.IsAntiVirus.ID.Value);
ClientsiteDevice.IsBackUpPolicy = new PolicyType();
ClientsiteDevice.IsBackUpPolicy.ID = Common.ConvertToInt(dr, "BackUpPolicyID");
ClientsiteDevice.IsBackUpPolicy.Name = LookUpValue.GetOptionType(ClientsiteDevice.IsBackUpPolicy.ID.Value);
ClientsiteDevice.IsRMMTool = new PolicyType();
ClientsiteDevice.IsRMMTool.ID = Common.ConvertToInt(dr, "ToolID");
ClientsiteDevice.IsRMMTool.Name = LookUpValue.GetOptionType(ClientsiteDevice.IsRMMTool.ID.Value);
}
}
return ClientsiteDevice;
}
public int SaveClientSiteDevice(tblClientSiteDevice clientSitedevice)
{
int errorNum = 0;
string errorDesc = "";
DataAccess.resetParams();
DataAccess.addSqlParam("@ClientSiteDeviceID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.DeviceID);
DataAccess.addSqlParam("@ClientID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.ClientID);
DataAccess.addSqlParam("@DeviceType", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.DeviceType.ID);
DataAccess.addSqlParam("@Description", ParameterDirection.Input, 100, MySqlDbType.VarChar, clientSitedevice.DeviceDescription);
DataAccess.addSqlParam("@DeviceIDFromRMMTool", ParameterDirection.Input, 100, MySqlDbType.VarChar, clientSitedevice.DeviceIDFromRMMTool);
DataAccess.addSqlParam("@MiscInfo", ParameterDirection.Input, 200, MySqlDbType.VarChar, clientSitedevice.MiscInfo);
DataAccess.addSqlParam("@UserName", ParameterDirection.Input, 100, MySqlDbType.VarChar, clientSitedevice.UserName);
DataAccess.addSqlParam("@Password", ParameterDirection.Input, 100, MySqlDbType.VarChar, clientSitedevice.Password);
DataAccess.addSqlParam("@AccessPolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.IsAccessPolicy.ID);
DataAccess.addSqlParam("@MaintenancePolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.IsMaintenancePolicy.ID);
DataAccess.addSqlParam("@PatchingPolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.IsPatchingPolicy.ID);
DataAccess.addSqlParam("@AntiVirusID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.IsAntiVirus == null ? 0:clientSitedevice.IsAntiVirus.ID);
DataAccess.addSqlParam("@BackUpPolicyID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.IsBackUpPolicy == null ? 0:clientSitedevice.IsBackUpPolicy.ID);
DataAccess.addSqlParam("@ToolID", ParameterDirection.Input, 16, MySqlDbType.Int32, clientSitedevice.IsRMMTool.ID);
DataAccess.addSqlParam("@Isactive", ParameterDirection.InputOutput, 16, MySqlDbType.Int16, 1);
DataAccess.addSqlParam("@Identity", ParameterDirection.InputOutput, 16, MySqlDbType.Int32);
DataAccess.ExecuteNonQuery(SET_CLIENT_SITE_DEVICE, ref errorNum, ref errorDesc);
return Common.ConvertToInt(DataAccess.getSQLParam("@Identity").ToString());
}