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)); }