public U_Profile Get(string uid, EnmProfile type)
{
SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.VarChar, 100),
new SqlParameter("@Type", SqlDbType.Int) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(uid);
parms[1].Value = (int)type;
U_Profile entity = null;
using (var rdr = SqlHelper.ExecuteReader(this._databaseConnectionString, CommandType.Text, SqlCommands_Sc.Sql_U_Profile_Repository_GetProfile, parms)) {
if (rdr.Read())
{
entity = new U_Profile {
UserId = SqlTypeConverter.DBNullStringHandler(rdr["UserId"]),
Type = SqlTypeConverter.DBNullProfileHandler(rdr["Type"]),
ValuesJson = SqlTypeConverter.DBNullStringHandler(rdr["ValuesJson"]),
ValuesBinary = SqlTypeConverter.DBNullBytesHandler(rdr["ValuesBinary"]),
LastUpdatedDate = SqlTypeConverter.DBNullDateTimeHandler(rdr["LastUpdatedDate"])
};
}
}
return(entity);
}
public void Delete(string uid, EnmProfile type)
{
SqlParameter[] parms = { new SqlParameter("@UserId", SqlDbType.VarChar, 100),
new SqlParameter("@Type", SqlDbType.Int) };
parms[0].Value = SqlTypeConverter.DBNullStringChecker(uid);
parms[1].Value = (int)type;
using (var conn = new SqlConnection(this._databaseConnectionString)) {
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
var trans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
try {
SqlHelper.ExecuteNonQuery(trans, CommandType.Text, SqlCommands_Sc.Sql_U_Profile_Repository_Delete, parms);
trans.Commit();
} catch {
trans.Rollback();
throw;
}
}
}
public void RemoveProfile(string uid, EnmProfile type)
{
_repository.Delete(uid, type);
}
public U_Profile GetProfile(string uid, EnmProfile type)
{
return(_repository.Get(uid, type));
}
