/// <summary>
/// Delete single item by ChatID
/// </summary>
public bool Delete(int id)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[bot].[RefusalWorkflowStatus_Delete]";
dataManager.Add("@ChatId", SqlDbType.BigInt, ParameterDirection.Input, id);
dataManager.ExecuteNonQuery();
}
return(true);
}
/// <summary>
/// Add or update item
/// </summary>
public UsageLog AddEdit(UsageLog entity)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[logs].[UsageLog_AddEdit]";
dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
dataManager.Add("@ActionType", SqlDbType.Int, ParameterDirection.Input, (int)entity.ActionType);
dataManager.Add("@PageUrl", SqlDbType.NVarChar, ParameterDirection.Input, entity.PageUrl);
dataManager.Add("@OccurredOn", SqlDbType.DateTime, ParameterDirection.Input, entity.OccurredOn);
dataManager.ExecuteNonQuery();
}
return(entity);
}
/// <summary>
/// Add or update item
/// </summary>
public Error AddEdit(Error entity)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[logs].[Error_AddEdit]";
dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
dataManager.Add("@ErrorCode", SqlDbType.BigInt, ParameterDirection.Input, entity.ErrorCode);
dataManager.Add("@ErrorMessage", SqlDbType.NVarChar, ParameterDirection.Input, entity.ErrorMessage);
dataManager.Add("@StackTrace", SqlDbType.NVarChar, ParameterDirection.Input, entity.StackTrace);
dataManager.ExecuteNonQuery();
}
return(entity);
}
/// <summary>
/// Add or update item
/// </summary>
public Days AddEdit(Days entity)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[dbo].[Days_AddEdit]";
dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
dataManager.Add("@CountryId", SqlDbType.Int, ParameterDirection.Input, entity.CountryId);
dataManager.Add("@CountryVisaId", SqlDbType.Int, ParameterDirection.Input, entity.CountryVisaId);
dataManager.Add("@Days", SqlDbType.Int, ParameterDirection.Input, entity.DaysCount);
dataManager.ExecuteNonQuery();
}
return(entity);
}
/// <summary>
/// Add or update item (NOT IMPLEMENTED)
/// </summary>
public Error AddEdit(Error entity)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[bot].[Product_AddEdit]";
dataManager.Add("@ChatId", SqlDbType.BigInt, ParameterDirection.Input, entity.ChatId);
dataManager.Add("@RefusalWorkflowStatusId", SqlDbType.Int, ParameterDirection.Input, (int)entity.RefusalWorkflowStatusId);
dataManager.Add("@ErrorCode", SqlDbType.BigInt, ParameterDirection.Input, entity.ErrorCode);
dataManager.Add("@ErrorMessage", SqlDbType.NVarChar, ParameterDirection.Input, entity.ErrorMessage);
dataManager.Add("@StackTrace", SqlDbType.NVarChar, ParameterDirection.Input, entity.StackTrace);
dataManager.ExecuteNonQuery();
}
return(entity);
}
/// <summary>
/// Add or update item
/// </summary>
public UserTrackingSchedule AddEdit(UserTrackingSchedule entity)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[dbo].[UserTrackingSchedule_AddEdit]";
dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
dataManager.Add("@ScheduledHours", SqlDbType.Int, ParameterDirection.Input, entity.ScheduledHours);
dataManager.Add("@ScheduledDays", SqlDbType.Int, ParameterDirection.Input, entity.ScheduledDays);
dataManager.Add("@ScheduledNotificationId", SqlDbType.NVarChar, ParameterDirection.Input, entity.ScheduledNotificationId);
dataManager.Add("@Enabled", SqlDbType.Int, ParameterDirection.Input, entity.Enabled);
dataManager.Add("@LastRun", SqlDbType.DateTime, ParameterDirection.Input, entity.LastRun);
dataManager.ExecuteNonQuery();
}
return(entity);
}
/// <summary>
/// Add or update item
/// </summary>
public Country AddEdit(Country entity)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[dict].[Country_AddEdit]";
dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
dataManager.Add("@Name", SqlDbType.NVarChar, ParameterDirection.Input, entity.Name);
dataManager.Add("@Code", SqlDbType.NVarChar, ParameterDirection.Input, entity.Code);
dataManager.Add("@FinancialPeriodDateStart", SqlDbType.DateTime, ParameterDirection.Input, entity.CountryFinancialPeriod.DateStart);
dataManager.Add("@FinancialPeriodDateEnd", SqlDbType.DateTime, ParameterDirection.Input, entity.CountryFinancialPeriod.DateEnd);
dataManager.Add("@IsDefault", SqlDbType.Bit, ParameterDirection.Input, entity.IsDefault);
dataManager.ExecuteNonQuery();
}
return(entity);
}
/// <summary>
/// Delete
/// </summary>
public bool Delete(int userId, int visaId)
{
bool result = true;
try
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[map].[UserCountryVisa_Delete]";
dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, userId);
dataManager.Add("@VisaId", SqlDbType.Int, ParameterDirection.Input, visaId);
dataManager.ExecuteNonQuery();
}
}
catch (Exception) { result = false; }
return(result);
}
/// <summary>
/// AddEdit User
/// </summary>
public User AddEdit(User entity)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[auth].[User_AddEdit]";
dataManager.Add("@UserName", SqlDbType.NVarChar, ParameterDirection.Input, entity.UserName);
dataManager.Add("@FirstName", SqlDbType.NVarChar, ParameterDirection.Input, entity.FirstName);
dataManager.Add("@LastName", SqlDbType.NVarChar, ParameterDirection.Input, entity.LastName);
dataManager.Add("@MiddleName", SqlDbType.NVarChar, ParameterDirection.Input, entity.MiddleName);
dataManager.Add("@EmployeeId", SqlDbType.BigInt, ParameterDirection.Input, entity.EmployeeId);
dataManager.Add("@PhoneNumber", SqlDbType.NVarChar, ParameterDirection.Input, entity.PhoneNumber);
dataManager.Add("@Email", SqlDbType.NVarChar, ParameterDirection.Input, entity.Email);
dataManager.Add("@StoreId", SqlDbType.Int, ParameterDirection.Input, entity.StoreId);
dataManager.Add("@Status", SqlDbType.Bit, ParameterDirection.Input, entity.Status);
dataManager.ExecuteNonQuery();
}
return(entity);
}
/// <summary>
/// Add or update item
/// </summary>
public UserCountryVisa AddEdit(UserCountryVisa entity)
{
using (var dataManager = new DataManager.Implementation.DataManager(ConnectionString))
{
dataManager.ExecuteString = "[map].[UserCountryVisa_AddEdit]";
dataManager.Add("@UserId", SqlDbType.Int, ParameterDirection.Input, entity.UserId);
dataManager.Add("@CountryId", SqlDbType.Int, ParameterDirection.Input, entity.CountryId);
dataManager.Add("@Name", SqlDbType.NVarChar, ParameterDirection.Input, entity.CountryVisa.Name);
dataManager.Add("@Code", SqlDbType.NVarChar, ParameterDirection.Input, entity.CountryVisa.Code);
dataManager.Add("@Description", SqlDbType.NVarChar, ParameterDirection.Input, entity.CountryVisa.Description);
dataManager.Add("@DateStart", SqlDbType.DateTime, ParameterDirection.Input, entity.CountryVisa.DateStart);
dataManager.Add("@DateEnd", SqlDbType.DateTime, ParameterDirection.Input, entity.CountryVisa.DateEnd);
dataManager.Add("@CountFirstDay", SqlDbType.Bit, ParameterDirection.Input, entity.CountryVisa.CountFirstDay);
dataManager.Add("@CountLastDay", SqlDbType.Bit, ParameterDirection.Input, entity.CountryVisa.CountLastDay);
dataManager.Add("@TargetDays", SqlDbType.Int, ParameterDirection.Input, entity.CountryVisa.TargetDays);
dataManager.Add("@SpecialTime", SqlDbType.NVarChar, ParameterDirection.Input, entity.CountryVisa.SpecialTime);
dataManager.Add("@AllowNotification", SqlDbType.Bit, ParameterDirection.Input, entity.AllowNotification);
dataManager.ExecuteNonQuery();
}
return(entity);
}
