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