public List <UserMini> Get()
{
List <UserMini> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.UserProfile_GetUserProfile"
, inputParamMapper : null
, map : delegate(IDataReader reader, short set)
{
UserMini uid = new UserMini();
int startingIndex = 0;
// REASSIGNED: UserMini Domain Model Id - From Int to String -
uid.Id = reader.GetSafeString(startingIndex++);
uid.FirstName = reader.GetSafeString(startingIndex++);
uid.LastName = reader.GetSafeString(startingIndex++);
uid.ProfileContent = reader.GetSafeString(startingIndex++);
uid.TagLine = reader.GetSafeString(startingIndex++);
uid.UserId = reader.GetSafeString(startingIndex++);
if (list == null)
{
list = new List <UserMini>();
}
list.Add(uid);
}
);
return(list);
}
public HttpResponseMessage LockUser(UserMini user)
{
OracleConnection connection = new OracleConnection(ConnectionString);
OracleCommand command;
try
{
connection.Open();
OracleCommand cmd = null;
cmd = new OracleCommand("WF_ADMIN_LOCK_USER");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = connection;
cmd.Parameters.Add("V_USER_CODE", OracleType.VarChar).Value = user.UserName;
cmd.Parameters.Add("V_COMPANY", OracleType.VarChar).Value = user.Company;
cmd.ExecuteNonQuery();
connection.Close();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
connection.Close();
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
public PaginatedItemsResponse <UserCredits> GetTransactionsPaginated(PaginatedRequest model)
{
List <UserCredits> TransactionsList = null;
PaginatedItemsResponse <UserCredits> response = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.UserCredits_SelectAll"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@CurrentPage", model.CurrentPage);
paramCollection.AddWithValue("@ItemsPerPage", model.ItemsPerPage);
paramCollection.AddWithValue("@Query", model.Query);
}, map : delegate(IDataReader reader, short set)
{
if (set == 0)
{
UserCredits data = new UserCredits();
int startingIndex = 0; //startingOrdinal
data.Id = reader.GetSafeInt32(startingIndex++);
data.UserId = reader.GetSafeString(startingIndex++);
data.Amount = reader.GetSafeDecimal(startingIndex++);
data.TransactionId = reader.GetSafeInt32(startingIndex++);
data.JobId = reader.GetSafeInt32(startingIndex++);
data.DateAdded = reader.GetSafeDateTime(startingIndex++);
UserMini User = new UserMini();
User.FirstName = reader.GetSafeString(startingIndex++);
User.LastName = reader.GetSafeString(startingIndex++);
User.Email = reader.GetSafeString(startingIndex++);
User.Phone = reader.GetSafeString(startingIndex++);
User.Url = reader.GetSafeString(startingIndex++);
data.User = User;
if (TransactionsList == null)
{
TransactionsList = new List <UserCredits>();
}
TransactionsList.Add(data);
}
else if (set == 1)
{
response = new PaginatedItemsResponse <UserCredits>();
response.TotalItems = reader.GetSafeInt32(0);
}
}
);
response.Items = TransactionsList;
response.CurrentPage = model.CurrentPage;
response.ItemsPerPage = model.ItemsPerPage;
return(response);
}
public static List <Events> GetByTagSlug(string slug)
{
List <Events> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Tags_SelectEventsByTag"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@TagSlug", slug);
}, map : delegate(IDataReader reader, short set)
{
int startingIndex = 0; //startingOrdinal
Events p = new Events();
p.Id = reader.GetInt32(startingIndex++);
p.UserId = reader.GetString(startingIndex++);
p.EventType = reader.GetSafeInt32(startingIndex++);
p.IsPublic = reader.GetSafeBool(startingIndex++);
p.Title = reader.GetString(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.CreateDate = reader.GetDateTime(startingIndex++);
p.ModifiedDate = reader.GetDateTime(startingIndex++);
p.Start = reader.GetDateTime(startingIndex++);
p.End = reader.GetSafeDateTime(startingIndex++);
p.MediaId = reader.GetSafeInt32(startingIndex++);
p.CountYes = reader.GetSafeInt32(startingIndex++);
p.CountNo = reader.GetSafeInt32(startingIndex++);
p.CountMaybe = reader.GetSafeInt32(startingIndex++);
Medias m = new Medias();
m.MediasTableId = reader.GetSafeInt32(startingIndex++);
m.CreatedDate = reader.GetSafeDateTime(startingIndex++);
m.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
m.MediaType = reader.GetSafeEnum <MediaType>(startingIndex++);
m.ContentType = reader.GetSafeString(startingIndex++);
m.UserId = reader.GetSafeString(startingIndex++);
m.FilePath = reader.GetSafeString(startingIndex++);
p.Media = m;
UserMini u = new UserMini();
u.profileName = reader.GetSafeString(startingIndex++);
u.profileLastName = reader.GetSafeString(startingIndex++);
p.Organizer = u;
if (list == null)
{
list = new List <Events>();
}
list.Add(p);
}
);
return(DecorateEvents(list)); //list of events that have a certain tag
}
public HttpResponseMessage UpdateUserPassword(UserMini user)
{
if (ValidatePasswordHistory(user.UserName, user.Company, user.NewPassword) == "0")
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "This password used recently. please choose a different one"));
}
PasswordAdvisor passwordAdvisor = new PasswordAdvisor();
if (passwordAdvisor.CheckStrength(user.NewPassword) != PasswordScore.Medium)
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed, "This password is too simple"));
}
OracleConnection connection = new OracleConnection(ConnectionString);
OracleCommand command;
try
{
connection.Open();
OracleCommand cmd = null;
cmd = new OracleCommand("UPDATE_USER_PASSWORD");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = connection;
cmd.Parameters.Add("V_USER_CODE", OracleType.VarChar).Value = user.UserName;
cmd.Parameters.Add("V_PASSWORD", OracleType.VarChar).Value = user.Password;
cmd.Parameters.Add("V_NEW_PASSWORD", OracleType.VarChar).Value = user.NewPassword;
cmd.Parameters.Add("V_COMPANY", OracleType.VarChar).Value = user.Company;
cmd.ExecuteNonQuery();
connection.Close();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception ex)
{
connection.Close();
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
public static List <MessageThreads> GetThreadsByGroupId(int GroupId, int pageNumber, int pageSize)
{
List <MessageThreads> list = null;
//get message threads by groupId
DataProvider.ExecuteCmd(GetConnection, "MessageThreads_JoinSearchByGroupId"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@GroupId", GroupId);
paramCollection.AddWithValue("@CurrentPage", pageNumber);
paramCollection.AddWithValue("@ItemsPerPage", pageSize);
}
, map : delegate(IDataReader reader, short set)
{
MessageThreads m = new MessageThreads();
int startingIndex = 0; //startingOrdinal
m.Id = reader.GetSafeInt32(startingIndex++);
m.ThreadTitle = reader.GetSafeString(startingIndex++);
m.UserId = reader.GetSafeString(startingIndex++);
m.CreatedDate = reader.GetSafeDateTime(startingIndex++);
m.LastMessageDate = reader.GetSafeDateTime(startingIndex++);
m.CommentCount = reader.GetSafeInt32(startingIndex++);
m.ViewCount = reader.GetSafeInt32(startingIndex++);
UserMini u = new UserMini();
u.profileName = reader.GetSafeString(startingIndex++);
u.profileLastName = reader.GetSafeString(startingIndex++);
u.UserId = reader.GetSafeString(startingIndex++);
m.UserInfo = u;
if (list == null)
{
list = new List <MessageThreads>();
}
list.Add(m);
}
);
return(list);
}
public static MessageThreads getThreadById(int ThreadId)
{
MessageThreads m = null;
DataProvider.ExecuteCmd(GetConnection, "MessageThreads_JoinSelectThreadInfoById"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@ThreadId", ThreadId);
}
, map : delegate(IDataReader reader, short set)
{
m = new MessageThreads();
int startingIndex = 0; //startingOrdinal
m.Id = reader.GetSafeInt32(startingIndex++);
m.ThreadTitle = reader.GetSafeString(startingIndex++);
m.UserId = reader.GetSafeString(startingIndex++);
m.CreatedDate = reader.GetSafeDateTime(startingIndex++);
m.LastMessageDate = reader.GetSafeDateTime(startingIndex++);
m.CommentCount = reader.GetSafeInt32(startingIndex++);
m.ViewCount = reader.GetSafeInt32(startingIndex++);
UserMini u = new UserMini();
u.profileName = reader.GetSafeString(startingIndex++);
u.profileLastName = reader.GetSafeString(startingIndex++);
u.UserId = reader.GetSafeString(startingIndex++);
m.UserInfo = u;
Groups g = new Groups();
g.Id = reader.GetSafeInt32(startingIndex++);
m.GroupInfo = g;
}
);
return(m);
}
public static List <Events> Get(EventsGetRequest model)
{
List <Events> list = null;
DataProvider.ExecuteCmd(GetConnection, "dbo.Events_SearchEpic"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@PageSize", model.PageSize);
paramCollection.AddWithValue("@PageNumber", model.PageNumber);
paramCollection.AddWithValue("@lat", model.Lat);
paramCollection.AddWithValue("@lon", model.Lon);
paramCollection.AddWithValue("@distance", model.Distance);
paramCollection.AddWithValue("@SearchString", model.SearchString);
}, map : delegate(IDataReader reader, short set) //executes after stored proc
{
Events p = new Events();
int startingIndex = 0; //startingOrdinal
p.Id = reader.GetSafeInt32(startingIndex++);
p.UserId = reader.GetSafeString(startingIndex++);
p.EventType = reader.GetSafeInt32(startingIndex++);
p.IsPublic = reader.GetSafeBool(startingIndex++);
p.Title = reader.GetString(startingIndex++);
p.Description = reader.GetSafeString(startingIndex++);
p.CountYes = reader.GetSafeInt32(startingIndex++);
p.CountNo = reader.GetSafeInt32(startingIndex++);
p.CountMaybe = reader.GetSafeInt32(startingIndex++);
p.CreateDate = reader.GetSafeDateTime(startingIndex++);
p.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
p.Start = reader.GetSafeDateTime(startingIndex++);
p.End = reader.GetSafeDateTime(startingIndex++);
p.MediaId = reader.GetSafeInt32(startingIndex++);
Medias m = new Medias();
m.MediasTableId = reader.GetSafeInt32(startingIndex++);
m.CreatedDate = reader.GetSafeDateTime(startingIndex++);
m.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
m.MediaType = reader.GetSafeEnum <MediaType>(startingIndex++);
m.ContentType = reader.GetSafeString(startingIndex++);
m.UserId = reader.GetSafeString(startingIndex++);
m.FilePath = reader.GetSafeString(startingIndex++);
if (m.MediasTableId > 0)
{
p.Media = m;
}
UserMini u = new UserMini();
u.profileName = reader.GetSafeString(startingIndex++);
u.profileLastName = reader.GetSafeString(startingIndex++);
u.UserId = reader.GetSafeString(startingIndex++);
Medias n = new Medias();
n.MediasTableId = reader.GetSafeInt32(startingIndex++);
n.CreatedDate = reader.GetSafeDateTime(startingIndex++);
n.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
n.MediaType = reader.GetSafeEnum <MediaType>(startingIndex++);
n.ContentType = reader.GetSafeString(startingIndex++);
n.UserId = reader.GetSafeString(startingIndex++);
n.FilePath = reader.GetSafeString(startingIndex++);
if (n.MediasTableId > 0)
{
u.Avatar = n;
}
p.Organizer = u;
Location l = new Location();
l.Id = reader.GetSafeInt32(startingIndex++);
l.Latitude = reader.GetSafeDecimal(startingIndex++);
l.Longitude = reader.GetSafeDecimal(startingIndex++);
l.Address = reader.GetSafeString(startingIndex++);
l.City = reader.GetSafeString(startingIndex++);
l.State = reader.GetSafeString(startingIndex++);
l.ZipCode = reader.GetSafeString(startingIndex++);
p.Location = l;
if (list == null)
{
list = new List <Events>();
}
list.Add(p);
}
);
return(DecorateEvents(list));
}
