public bool Delete(int id, string currUser)
{
try
{
using (GBHODBEntities db = new GBHODBEntities())
{
Product item = db.Products.SingleOrDefault(x => x.ProductId == id);
if (item != null)
{
item.ModifiedBy = currUser;
item.ModifiedDate = DateHelper.DateTimeNow;
item.RecState = "D";
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch
{
return(false);
}
}
public int GetTotalDirectReferrals(int memberId)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return(db.Members.Count(x => x.RecState == "A" && x.SponsorId == memberId));
}
}
public bool SaveSetting(List <Setting> settings, string user)
{
bool result = false;
try
{
using (GBHODBEntities db = new GBHODBEntities())
{
settings = settings.Where(x => x.Type == typeUser).ToList();
foreach (Setting setting in settings)
{
Setting item = db.Settings.SingleOrDefault(x => x.SettingId == setting.SettingId);
if (item != null)
{
item.Value = setting.Value;
item.ModifiedBy = user;
item.ModifiedDate = DateHelper.DateTimeNow;
db.SaveChanges();
}
}
result = true;
}
}
catch
{
result = false;
}
return(result);
}
public void SubmitOrder(long orderId, List <OrderItem> cart, int orderByUserId, string orderBy, string processedBy)
{
using (GBHODBEntities db = new GBHODBEntities())
{
Order order = db.Orders.Where(x => x.OrderId == orderId).First();
order.Status = "Processed";
order.ModifiedBy = processedBy;
order.ModifiedDate = DateHelper.DateTimeNow;
order.OrderDate = DateHelper.DateTimeNow;
order.OrderBy = orderBy;
order.OrderFor = orderBy;
order.MemberId = orderByUserId;
order.ProcessedBy = processedBy;
order.ProcessedDate = DateHelper.DateTimeNow;
foreach (var item in cart)
{
OrderItem orderItem = db.OrderItems.Where(x => x.OrderItemId == item.OrderItemId).FirstOrDefault();
if (orderItem != null)
{
orderItem.QTY = item.QTY;
}
}
db.SaveChanges();
}
}
public void ProcessRebatesCleanUp()
{
using (GBHODBEntities db = new GBHODBEntities())
{
db.ProcessRebatesCleanUp();
}
}
public int GetDefaultRole()
{
using (GBHODBEntities db = new GBHODBEntities())
{
return(db.Roles.Where(x => x.RoleCode == "Member").First().RoleId);
}
}
public void ProcessRebatesReport()
{
using (GBHODBEntities db = new GBHODBEntities())
{
db.ProcessRebatesReport();
}
}
public string GetValue(string key)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return(db.Settings.First(x => x.Key == key).Value);
}
}
private long SaveOrder(int productId, int memberId, string currUser)
{
long orderId = 0;
using (GBHODBEntities db = new GBHODBEntities())
{
Order order = db.Orders.Where(x => x.Status == "Pending" && x.RecState == "A" && x.MemberId == memberId).FirstOrDefault();
if (order == null)
{
order = new Order();
order.MemberId = memberId;
order.Status = "Pending";
order.RecState = "A";
order.CreatedDate = DateHelper.DateTimeNow;
order.CreatedBy = currUser;
db.Orders.Add(order);
}
else
{
order.ModifiedBy = currUser;
order.ModifiedDate = DateHelper.DateTimeNow;
}
db.SaveChanges();
orderId = order.OrderId;
}
return(orderId);
}
public List <Role> GetAllRoles()
{
using (GBHODBEntities db = new GBHODBEntities())
{
return(db.Roles.Where(x => x.RoleCode != "DevAdmin").ToList());
}
}
public void UpdateMemberType(int memberId, string status, string user)
{
using (GBHODBEntities db = new GBHODBEntities())
{
if (status != "approve")
{
Member approver = db.Members.First(x => x.MemberId == memberId);
bool hasChildPending = db.Members.Count(x => x.RecState == "A" && x.HierarchyCode.StartsWith(approver.HierarchyCode) && x.MemberId != memberId) > 0;
if (hasChildPending)
{
throw new Exception("Unable to cancel approval, this member has already approved/pending downline.");
}
}
Member item = db.Members.SingleOrDefault(x => x.MemberId == memberId);
if (item != null)
{
item.Type = status == "approve" ? "Active" : "Cancelled";
item.RecState = status == "approve" ? "A" : "D";
item.ApprovedBy = user;
item.ApprovedDate = DateHelper.DateTimeNow;
db.SaveChanges();
}
}
}
public Product Get(int id)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Products
where x.ProductId == id
select x).FirstOrDefault());
}
}
public List <Member> GetMyDirectReferrals(int memberId)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Members
where x.RecState == "A" & x.Type != "System" & x.SponsorId == memberId
select x).OrderByDescending(x => x.DateJoined).ToList());
}
}
public string GetHierarchyCode(int id)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Members
where x.MemberId == id
select x.HierarchyCode).FirstOrDefault());
}
}
public string GetFullName(int id)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Members
where x.MemberId == id
select x.FirstName + " " + x.LastName).FirstOrDefault());
}
}
public List <OrderReports_Result> GetOrders(DateTime dt, string admin)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.OrderReports(admin, dt)
select x).OrderBy(x => x.OrderId)
.ToList());
}
}
public List <Product> GetAll()
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Products
where x.RecState == "A"
select x).OrderBy(x => x.ProductName).ToList());
}
}
public List <Member> GetMyGeneology(string hCode)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Members
where x.RecState == "A" & x.Type != "System" & x.HierarchyCode.Contains(hCode)
select x).OrderBy(x => x.HierarchyCode.Length).ThenBy(x => x.HierarchyCode).ToList());
}
}
public List <Setting> GetAll()
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Settings
where x.RecState == "A"
select x).ToList());
}
}
public bool HasEditable()
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Settings
where x.RecState == "A" && x.Type == typeUser
select x).Count() > 0);
}
}
public Member Get(int id)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Members
where x.MemberId == id
select x).FirstOrDefault());
}
}
public int GetPendingItemCount(int memberId)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from o in db.Orders
join oi in db.OrderItems on o.OrderId equals oi.OrderId
where o.Status == "Pending" && o.MemberId == memberId && o.RecState == "A"
select oi).Count());
}
}
public List <Member> GetAllAdmin()
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Members
where x.RecState == "A" & (x.Role.RoleCode == "Admin" | x.Role.RoleCode == "SuperAdmin")
select x).OrderBy(x => x.LastName)
.ThenBy(x => x.FirstName).ToList());
}
}
public List <Member> GetAllForApproval()
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Members
where x.RecState == "A" & x.Type == "ForApproval"
select x).OrderBy(x => x.LastName)
.ThenBy(x => x.FirstName).ToList());
}
}
public List <Member> GetAllWithhDevAdmin()
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.Members
where x.RecState == "A"
select x).OrderBy(x => x.LastName)
.ThenBy(x => x.FirstName).ToList());
}
}
public List <BinaryIncome_Result> GetBinaryIncome(int memberId, DateTime dt)
{
using (GBHODBEntities db = new GBHODBEntities())
{
return((from x in db.BinaryIncome(memberId, dt)
select x)
.OrderBy(x => x.DATE)
.ToList());
}
}
public Member Get(string username)
{
using (GBHODBEntities db = new GBHODBEntities())
{
Member item = (from x in db.Members
where x.Username == username
select x).FirstOrDefault();
return(item);
}
}
public void SaveMemberLastLoggedOn(int id)
{
using (GBHODBEntities db = new GBHODBEntities())
{
Member item = db.Members.SingleOrDefault(x => x.MemberId == id);
if (item != null)
{
item.LastLoggedIn = DateHelper.DateTimeNow;
db.SaveChanges();
}
}
}
public RebatesByMember_Result GetMyRebates(DateTime dt, int userId)
{
using (GBHODBEntities db = new GBHODBEntities())
{
bool hasGroupBonus = IsFirstWeek(dt);
return((from x in db.RebatesByMember(dt, hasGroupBonus, userId)
select x).OrderBy(x => x.LastName)
.ThenBy(x => x.FirstName)
.ThenBy(x => x.MemberID)
.FirstOrDefault());
}
}
public void RemoveOrderItem(long orderItemId)
{
using (GBHODBEntities db = new GBHODBEntities())
{
var item = (from x in db.OrderItems
where x.OrderItemId == orderItemId
select x).FirstOrDefault();
db.OrderItems.Remove(item);
db.SaveChanges();
}
}
