/// <summary>
/// Adaugare Clinet in Db
/// Arunca ValidationException daca clientul nu e valid
/// </summary>
/// <param name="entity">Clientul de adaugagt</param>
public void Add(Client entity)
{
var con = SQLiteConnectionFactory.GetInstance().CreateConnection();
ValidatorClient.Validate(entity);
using (var comm = con.CreateCommand())
{
comm.CommandText = "insert into Clienti values (@id,@nume,@prenume)";
var paramId = comm.CreateParameter();
paramId.ParameterName = "@id";
paramId.Value = entity.Id;
comm.Parameters.Add(paramId);
var paramNume = comm.CreateParameter();
paramNume.ParameterName = "@nume";
paramNume.Value = entity.Nume;
comm.Parameters.Add(paramNume);
var paramPreNume = comm.CreateParameter();
paramPreNume.ParameterName = "@prenume";
paramPreNume.Value = entity.Prenume;
comm.Parameters.Add(paramPreNume);
var result = comm.ExecuteNonQuery();
if (result == 0)
{
throw new RepositoryException("Clientul nu a fost adaugat!");
}
}
con.Close();
}
/// <summary>
/// Used for validating room keys.
/// </summary>
/// <param name="roomKey">Value to validate.</param>
/// <returns>Returns string array with errors.</returns>
static public string[] ValidRoomKey(string roomKey)
{
ValidatorClient validator = new ValidatorClient("Room key",
new List <IValidator>()
{
new NullInputValidator(),
new NoSpaceInputValidator(),
new SqlInjectionInputValidator(),
new ExactLengthInputValidator(ServiceFactory.RoomKeyLength)
});
validator.Validate(roomKey).Wait();
return(validator.Errors.ToArray());
}
/// <summary>
/// Used for validating room names.
/// </summary>
/// <param name="roomName">Value to validate.</param>
/// <returns>Returns string array with errors.</returns>
static public string[] ValidRoomName(string roomName)
{
ValidatorClient validator = new ValidatorClient("Room name",
new List <IValidator>()
{
new NullInputValidator(),
new SqlInjectionInputValidator(),
new MaxLengthInputValidator(80),
new MinLengthInputValidator(5)
});
validator.Validate(roomName).Wait();
return(validator.Errors.ToArray());
}
/// <summary>
/// Used for validating password.
/// </summary>
/// <param name="email">Value to validate.</param>
/// <returns>Returns string array with errors.</returns>
static public string[] ValidPassword(string password)
{
List <IValidator> passwordRules = new List <IValidator>()
{
new NullInputValidator(),
new MaxLengthInputValidator(250),
new MinLengthInputValidator(6),
new PasswordRequirementInputValidator()
};
var validator = new ValidatorClient("Password", passwordRules);
validator.Validate(password).Wait();
return(validator.Errors.ToArray());
}
/// <summary>
/// Used for validating username.
/// </summary>
/// <param name="email">Value to validate.</param>
/// <returns>Returns string array with errors.</returns>
static public string[] ValidUsername(string username)
{
List <IValidator> usernameRules = new List <IValidator>()
{
new NullInputValidator(),
new NoSpaceInputValidator(),
new SqlInjectionInputValidator(),
new MaxLengthInputValidator(75),
new MinLengthInputValidator(5)
};
var validator = new ValidatorClient("Username", usernameRules);
validator.Validate(username).Wait();
return(validator.Errors.ToArray());
}
/// <summary>
/// Used for validating emails when loggin in with email.
/// </summary>
/// <param name="email">Value to validate.</param>
/// <returns>Returns string array with errors.</returns>
static public string[] ValidEmailLogin(string email)
{
List <IValidator> emailRules = new List <IValidator>()
{
new NullInputValidator(),
new NoSpaceInputValidator(),
new MaxLengthInputValidator(250),
new MinLengthInputValidator(5),
new SqlInjectionInputValidator()
};
var emailValidator = new ValidatorClient("Email", emailRules);
emailValidator.Validate(email).Wait();
return(emailValidator.Errors.ToArray());
}
static public async Task <string[]> ValidEmailCreateNewAsync(string email)
{
List <IValidator> emailRules = new List <IValidator>()
{
new NullInputValidator(),
new NoSpaceInputValidator(),
new MaxLengthInputValidator(250),
new MinLengthInputValidator(5),
new SqlInjectionInputValidator(),
new UniqueUserInputValidator()
};
var emailValidator = new ValidatorClient("Email", emailRules);
await emailValidator.Validate(email);
return(emailValidator.Errors.ToArray());
}
public void Add(Client entity)
{
_validator.Validate(entity);
_listaClienti.Add(entity);
}
