/// <summary>
/// Get list
/// </summary>
public List <AppSettings> List()
{
var entities = new List <AppSettings>();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[conf].[AppSettings_List]";
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
entities.UnpackXML(xmlOut);
}
return(entities);
}
/// <summary>
/// Get single item
/// </summary>
public UserTrackingSchedule Get(int id)
{
var entity = new UserTrackingSchedule();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[dbo].[UserTrackingSchedule_Get]";
dataManager.Add("@Id", SqlDbType.Int, ParameterDirection.Input, id);
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
entity.UnpackXML(xmlOut.Element("UserTrackingSchedule"));
}
return(entity);
}
/// <summary>
/// Get list by filter
/// </summary>
public List <UserTrackingSchedule> List(UserTrackingSchedule entity)
{
var entities = new List <UserTrackingSchedule>();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[dbo].[UserTrackingSchedule_List]";
dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
entities.UnpackXML(xmlOut);
}
return(entities);
}
/// <summary>
/// Get single item by key
/// </summary>
public AppSettings GetByKey(string key)
{
var entity = new AppSettings();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[conf].[AppSettings_GetByKey]";
dataManager.Add("@Key", SqlDbType.NVarChar, ParameterDirection.Input, key);
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
entity.UnpackXML(xmlOut.Element("AppSetting"));
}
return(entity);
}
/// <summary>
/// Get single item by ChatID
/// </summary>
public RefusalWorkflowStatus Get(int id)
{
var entity = new RefusalWorkflowStatus();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[bot].[RefusalWorkflowStatus_Get]";
dataManager.Add("@ChatId", SqlDbType.BigInt, ParameterDirection.Input, id);
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
entity.UnpackXML(xmlOut.Element("RefusalWorkflowStatus"));
}
return(entity);
}
/// <summary>
/// Get single item by QR code
/// </summary>
public Device GetByQr(string qrcode)
{
var entity = new Device();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[dbo].[Device_GetByOR]";
dataManager.Add("@QRCode", SqlDbType.NVarChar, ParameterDirection.Input, qrcode);
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
entity.UnpackXML(xmlOut.Element("Device"));
}
return(entity);
}
/// <summary>
/// Get single item (NOT IMPLEMENTED)
/// </summary>
public Product Get(int id)
{
var entity = new Product();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[bot].[Product_Get]";
dataManager.Add("@Id", SqlDbType.Int, ParameterDirection.Input, id);
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
entity.UnpackXML(xmlOut.Element("Product"));
}
return(entity);
}
/// <summary>
/// Get user by accesscode if the user is exist
/// </summary>
public User Login(string login)
{
var user = new User();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[auth].[User_Login]";
dataManager.Add("@UserName", SqlDbType.NVarChar, ParameterDirection.Input, login);
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
user.UnpackXML(xmlOut.Element("User"));
}
return(user);
}
/// <summary>
/// Get User by userid
/// </summary>
public User Get(int id)
{
var user = new User();
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[auth].[User_Get]";
dataManager.Add("@Id", SqlDbType.Int, ParameterDirection.Input, id);
dataManager.Add("@Xml", SqlDbType.Xml, ParameterDirection.Output);
dataManager.ExecuteReader();
XElement xmlOut = XElement.Parse(dataManager["@Xml"].Value.ToString());
user.UnpackXML(xmlOut.Element("User"));
}
return(user);
}
