private async Task <DataBaseParameter[]> GetDbParameters(ProcedureName procedureName, DbRequestToken token, params ProcedureParameter[] parameters)
{
var result = new DataBaseParameter[parameters.Length];
for (var i = 0; i < parameters.Length; ++i)
{
result[i] = await GetDbParameter(procedureName, token, parameters[i]);
}
return(result);
}
internal bool Delete(int userCode)
{
string queryString = @" DELETE FROM USER_TEST WHERE COD_USER = @COD_USER";
DataBaseParameter[] parameters = new DataBaseParameter[]
{
new DataBaseParameter("COD_USER", userCode)
};
int deleted = this.dbBase.ExecuteNonQuery(queryString, parameters);
return(deleted == 1);
}
internal DataResultRecord FindByCode(int userCode)
{
string queryString = @" SELECT COD_USER, USER_NAME, COD_USER_REF, PASSWORD_MD5, INPUT_DATE, USER_STATUS
FROM USER_TEST
WHERE COD_USER = @COD_USER";
DataBaseParameter[] parameters = new DataBaseParameter[]
{
new DataBaseParameter("COD_USER", userCode),
};
return(this.dbBase.GetSingleRecord(queryString, parameters));
}
internal DataResultRecord FindByID(int ID)
{
string queryString = @" SELECT COD_USER, USER_NAME, COD_USER_REF, PASSWORD_MD5, INPUT_DATE
FROM USER_TEST
WHERE ID_USER = @ID_USER";
DataBaseParameter[] parameters = new DataBaseParameter[]
{
new DataBaseParameter("ID_USER", ID),
};
return(this.dbBase.GetSingleRecord(queryString, parameters));
}
private async Task <DataBaseParameter> GetDbParameter(ProcedureName procedureName, DbRequestToken token, ProcedureParameter parameter)
{
var dbParam = new DataBaseParameter(parameter);
if (parameter.DbType.HasValue)
{
return(dbParam);
}
var procNameParam = new ProcedureParameter("procedureName", procedureName.GetStringName())
{
DbType = SqlDbType.NVarChar
};
var res = (await ExecProcedure <ProcedureParameterDescription>(ProcedureName.spInternalGetProcedureParameters, token, procNameParam)).Single();
dbParam.DbType = (SqlDbType)Enum.Parse(typeof(SqlDbType), res.ToString());
return(dbParam);
}
internal bool Insert(int userCode, string userName, long?userCodeRef, string passwordMd5, DateTime inputDate, StatusUser status)
{
string queryString = @" INSERT INTO USER_TEST (COD_USER, USER_NAME, COD_USER_REF, PASSWORD_MD5, INPUT_DATE, USER_STATUS)
VALUES(@COD_USER, @USER_NAME, @COD_USER_REF, @PASSWORD_MD5, @INPUT_DATE, @USER_STATUS)";
DataBaseParameter[] parameters = new DataBaseParameter[]
{
new DataBaseParameter("COD_USER", userCode),
new DataBaseParameter("USER_NAME", userName),
new DataBaseParameter("COD_USER_REF", userCodeRef),
new DataBaseParameter("PASSWORD_MD5", passwordMd5),
new DataBaseParameter("INPUT_DATE", inputDate),
new DataBaseParameter("USER_STATUS", (char)status),
};
int inserted = this.dbBase.ExecuteNonQuery(queryString, parameters);
return(inserted == 1);
}
internal int Update(int oldCode, int userCode, string userName, long?userCodeRef, string passwordMd5, DateTime inputDate, StatusUser status)
{
string queryString = @" UPDATE USER_TEST
SET COD_USER = @COD_USER,
USER_NAME = @USER_NAME,
COD_USER_REF = @COD_USER_REF,
PASSWORD_MD5 = @PASSWORD_MD5,
INPUT_DATE = @INPUT_DATE,
USER_STATUS = @USER_STATUS
WHERE COD_USER = @OLD_COD_USER";
DataBaseParameter[] parameters = new DataBaseParameter[]
{
new DataBaseParameter("OLD_COD_USER", oldCode),
new DataBaseParameter("COD_USER", userCode),
new DataBaseParameter("USER_NAME", userName),
new DataBaseParameter("COD_USER_REF", userCodeRef),
new DataBaseParameter("PASSWORD_MD5", passwordMd5),
new DataBaseParameter("INPUT_DATE", inputDate),
new DataBaseParameter("USER_STATUS", (char)status),
};
return(this.dbBase.ExecuteNonQuery(queryString, parameters));
}
