public User Load(ISqlConnectionInfo connection, string username, string password)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = string.Format("[u].Username = @Username");
parameters.Arguments.Add("Username", username);
User user = Load(connection, parameters);
if (user == null)
{
return(null);
}
int SALT_LENGTH = 8;
byte[] salt = new byte[SALT_LENGTH];
for (int i = 0; i < SALT_LENGTH;
salt[i] = user.Password[user.Password.Length - SALT_LENGTH + i++])
{
;
}
byte[] encryptedUnckeckedPassword = PasswordEncryption.Create(password, salt).EncryptedPasswordAndSalt;
if (encryptedUnckeckedPassword.SequenceEqual(user.Password))
{
return(user);
}
return(null);
}
public List <ServiceSendNumberMap> Load(ISqlConnectionInfo connection, Service service)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[ssnm].ServiceID=@ServiceID AND IsActive=1";
parameters.Arguments.Add("ServiceID", service.ID);
return(this.LoadMany(connection, parameters));
}
public List <BehaviorModel> Load(ISqlConnectionInfo connection, string name)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[bm].Name=@Name";
parameters.Arguments.Add("Name", name);
return(this.LoadMany(connection, parameters));
}
public PaymentInterface Load(ISqlConnectionInfo connection, Guid value)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[pi].ExternalPaymentInterfaceGuid = @ExternalPaymentInterfaceGuid";
parameters.Arguments.Add("ExternalPaymentInterfaceGuid", value);
return(this.Load(connection, parameters));
}
public Customer Load(ISqlConnectionInfo connection, string name)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[i].Name = @Name";
parameters.Arguments.Add("Name", name);
return(this.Load(connection, parameters));
}
public Customer Load(ISqlConnectionInfo connection, Guid customerGuid)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[c].CustomerGuid = @CustomerGuid";
parameters.Arguments.Add("CustomerGuid", customerGuid);
return(this.Load(connection, parameters));
}
public UserSession Load(ISqlConnectionInfo connection, Guid userSessionGuid)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[us].UserSessionGuid = @UserSessionGuid";
parameters.Arguments.Add("UserSessionGuid", userSessionGuid);
return(this.Load(connection, parameters));
}
public List <Merchant> Load(ISqlConnectionInfo connection, Instance instance)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[m].InstanceID=@InstanceID";
parameters.Arguments.Add("InstanceID", instance.ID);
return(this.LoadMany(connection, parameters));
}
public List <TranslationKey> Load(ISqlConnectionInfo connection, TranslationKey translationKey)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[tk].FallbackTranslationKeyID=@TranslationKeyID";
parameters.Arguments.Add("TranslationKeyID", translationKey.ID);
return(this.LoadMany(connection, parameters));
}
public List <TranslationKey> Load(ISqlConnectionInfo connection, Product product)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[tk_t_p].ProductID = @ProductID";
parameters.Arguments.Add("ProductID", product.ID);
return(this.LoadMany(connection, parameters));
}
public ReportLinkGroup Load(ISqlConnectionInfo connection, string name)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[rlg].Name=@Name";
parameters.Arguments.Add("Name", name);
return(this.Load(connection, parameters));
}
public List <CallbackReport> Load(ISqlConnectionInfo connection, CallbackNotificationType type)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[cr].CallbackNotificationTypeID = @CallbackNotificationTypeID";
parameters.Arguments.Add("CallbackNotificationTypeID", (int)type);
return(this.LoadMany(connection, parameters));
}
public List <ApplicationRouteSetMap> Load(ISqlConnectionInfo connection, Application application)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[arsm].ApplicationID = @ApplicationID";
parameters.Arguments.Add("ApplicationID", application.ID);
return(this.LoadMany(connection, parameters));
}
public Service Load(ISqlConnectionInfo connection, ServiceConfiguration serviceConfiguration)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[s].ServiceConfigurationID = @ServiceConfigurationID";
parameters.Arguments.Add("ServiceConfigurationID", serviceConfiguration.ID);
return(this.Load(connection, parameters));
}
public Service Load(ISqlConnectionInfo connection, string serviceName)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[s].ServiceName = @ServiceName";
parameters.Arguments.Add("ServiceName", serviceName);
return(this.Load(connection, parameters));
}
public List <ServiceConfigurationEntry> Load(ISqlConnectionInfo connection, Service service)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[sce].ServiceConfigurationID = @ServiceConfigurationID";
parameters.Arguments.Add("ServiceConfigurationID", service.ServiceConfiguration.ID);
return(this.LoadMany(connection, parameters));
}
public List <Route> Load(ISqlConnectionInfo connection, RouteSet routeSet)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[r].RouteSetID=@RouteSetID";
parameters.Arguments.Add("RouteSetID", routeSet.ID);
return(this.LoadMany(connection, parameters));
}
public TranslationKey Load(ISqlConnectionInfo connection, Language language)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[tk].LanguageID = @LanguageID AND ( [tk].FallbackTranslationKeyID=1 OR [tk].ServiceID IS NULL )";
parameters.Arguments.Add("LanguageID", language.ID);
return(this.Load(connection, parameters));
}
public UserDetail Load(ISqlConnectionInfo connection, User user)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[ud].UserID=@UserID";
parameters.Arguments.Add("UserID", user.ID);
return(this.Load(connection, parameters));
}
public List <ServiceProfileGroupMap> Load(ISqlConnectionInfo connection, MobiChat.Data.Service service)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[spgm].ServiceID = @ServiceID";
parameters.Arguments.Add("ServiceID", service.ID);
return(this.LoadMany(connection, parameters));
}
public List <ProfileThumbnailData> Load(ISqlConnectionInfo connection, ProfileThumbnail profileThumbnail)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[ptd].ProfileThumbnailID = @ProfileThumbnailID";
parameters.Arguments.Add("ProfileThumbnailID", profileThumbnail.ID);
return(this.LoadMany(connection, parameters));
}
public List <User> Load(ISqlConnectionInfo connection, UserStatus userStatus)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[u].UserStatusID = @UserStatusID";
parameters.Arguments.Add("UserStatusID", (int)userStatus);
return(this.LoadMany(connection, parameters));
}
public List <Customer> Load(ISqlConnectionInfo connection, Service service)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[c].ServiceID = @ServiceID";
parameters.Arguments.Add("ServiceID", service.ID);
return(this.LoadMany(connection, parameters));
}
public User Load(ISqlConnectionInfo connection, string username)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[u].Username=@username";
parameters.Arguments.Add("username", username);
return(this.Load(connection, parameters));
}
public ShortMessageRequest Load(ISqlConnectionInfo connection, Guid guid)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[smr].ShortMessageRequestGuid = @ShortMessageRequestGuid";
parameters.Arguments.Add("ShortMessageRequestGuid", guid);
return(this.Load(connection, parameters));
}
public Application Load(ISqlConnectionInfo connection, string applicationName)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[a].Name = @Name";
parameters.Arguments.Add("Name", applicationName);
return(this.Load(connection, parameters));
}
public BehaviorModel Load(ISqlConnectionInfo connection, Guid value)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[bm].ExternalBehaviorModelGuid = @ExternalBehaviorModelGuid";
parameters.Arguments.Add("ExternalBehaviorModelGuid", value);
return(this.Load(connection, parameters));
}
public ServiceLogo Load(ISqlConnectionInfo connection, Service service)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[sl].ServiceID=@ServiceID";
parameters.Arguments.Add("ServiceID", service.ID);
return(this.Load(connection, parameters));
}
public List <MobileOperator> Load(ISqlConnectionInfo connection, Country country)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[mo].CountryID = @CountryID";
parameters.Arguments.Add("CountryID", country.ID);
return(this.LoadMany(connection, parameters));
}
public List <TranslationGroupKey> Load(ISqlConnectionInfo connection, TranslationGroup translationGroup)
{
SqlQueryParameters parameters = new SqlQueryParameters();
parameters.Where = "[tgk_tg].TranslationGroupID = @TranslationGroupID";
parameters.Arguments.Add("TranslationGroupID", translationGroup.ID);
return(this.LoadMany(connection, parameters));
}
