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 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();
}
}
}
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 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 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 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 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();
}
}
//public void ProcessOrder(long orderId, string currUser)
//{
// using (GBHODBEntities db = new GBHODBEntities())
// {
// Order order = db.Orders.Where(x => x.OrderId == orderId).First();
// order.Status = "Processed";
// order.ModifiedBy = currUser;
// order.ModifiedDate = DateHelper.DateTimeNow;
// order.ProcessedBy = currUser;
// order.ProcessedDate = DateHelper.DateTimeNow;
// db.SaveChanges();
// }
//}
public void CancelOrder(long orderId, string currUser)
{
using (GBHODBEntities db = new GBHODBEntities())
{
Order order = db.Orders.Where(x => x.OrderId == orderId).First();
order.Status = "Cancelled";
order.ModifiedBy = currUser;
order.ModifiedDate = DateHelper.DateTimeNow;
order.ProcessedBy = currUser;
order.ProcessedDate = DateHelper.DateTimeNow;
db.SaveChanges();
}
}
public bool Save(Product product, string currUser)
{
try
{
using (GBHODBEntities db = new GBHODBEntities())
{
Product item = db.Products.SingleOrDefault(x => x.ProductId == product.ProductId);
if (item == null)
{
item = new Product();
}
item.ProductName = product.ProductName;
item.Description = product.Description;
item.Amount = product.Amount;
item.Points = product.Points;
if (!string.IsNullOrEmpty(product.Picture))
{
item.Picture = product.Picture;
}
if (item.ProductId == 0)
{
item.RecState = "A";
item.CreatedDate = DateHelper.DateTimeNow;
item.CreatedBy = currUser;
db.Products.Add(item);
}
else
{
item.ModifiedBy = currUser;
item.ModifiedDate = DateHelper.DateTimeNow;
}
db.SaveChanges();
}
return(true);
}
catch
{
return(false);
}
}
public string ChangePassword(int memberId, string newPWD, string confirmPWD)
{
string e_newPWD = EncryptionManager.encrypt(newPWD);
string e_confirmPWD = EncryptionManager.encrypt(confirmPWD);
using (GBHODBEntities db = new GBHODBEntities())
{
//validate new and confirm password
if (e_newPWD == e_confirmPWD)
{
//validate old password
int checkOld = db.Members.Count(x => x.MemberId == memberId);
if (checkOld > 0)
{
//validate new password is unique
int checkUnique = db.Members.Count(x => x.MemberId == memberId && x.Password != e_newPWD);
if (checkUnique > 0)
{
Member item = db.Members.SingleOrDefault(x => x.MemberId == memberId);
item.Password = e_newPWD;
db.SaveChanges();
return(string.Empty);
}
else
{
return("PasswordErrorMsg2");
}
}
else
{
return("PasswordErrorMsg1");
}
}
else
{
return("PasswordErrorMsg1");
}
}
}
public void AddToCart(int productId, int memberId, string currUser)
{
long orderId = SaveOrder(productId, memberId, currUser);
using (GBHODBEntities db = new GBHODBEntities())
{
Product product = db.Products.Where(x => x.ProductId == productId).FirstOrDefault();
OrderItem orderItem = db.OrderItems.Where(x => x.ProductId == productId && x.OrderId == orderId).FirstOrDefault();
if (orderItem == null)
{
orderItem = new OrderItem();
orderItem.OrderId = orderId;
orderItem.ProductId = productId;
orderItem.Amount = product.Amount;
orderItem.QTY = 1;
orderItem.Points = product.Points;
db.OrderItems.Add(orderItem);
db.SaveChanges();
}
}
}
public int SaveMember(Member member, string currUser)
{
int memberId = member.MemberId;
using (GBHODBEntities db = new GBHODBEntities())
{
#region validate member code (hidden)
////validate member code
//bool isCodeExists = db.Members.Count(x => x.MemberId != member.MemberId && x.MemberCode == member.MemberCode && x.RecState == "A") > 0;
//if (isCodeExists)
//{
// throw new Exception("Member ID already exists. Please enter a different member ID.");
//}
//else
//{
//}
#endregion
//validate username
bool isUsernameExists = db.Members.Count(x => x.MemberId != member.MemberId && x.Username == member.Username && x.RecState == "A") > 0;
if (isUsernameExists)
{
throw new Exception("User name ID already exists. Please enter a different user name");
}
else
{
// validate placement
bool isPlaceExists = false;
string hCode = string.Empty;
if (member.ParentId > 0)
{
string parentHCode = db.Members.SingleOrDefault(x => x.MemberId == member.ParentId).HierarchyCode;
hCode = parentHCode + member.HierarchyCode.Substring(member.HierarchyCode.Length - 1, 1);
isPlaceExists = db.Members.Count(x => x.MemberId != member.MemberId && x.HierarchyCode == hCode && x.RecState == "A") > 0;
}
if (isPlaceExists)
{
throw new Exception("Selected placement/group is already occupied. Please enter a different placement/group.");
}
else
{
int lastId = db.Members.OrderByDescending(x => x.MemberId).First().MemberId;
Member item = db.Members.SingleOrDefault(x => x.MemberId == member.MemberId);
if (item == null)
{
item = new Member();
}
item.Code = member.Code;
item.Username = member.Username;
item.FirstName = member.FirstName;
item.MiddleName = member.MiddleName;
item.LastName = member.LastName;
item.Email = member.Email;
item.MobileNo = member.MobileNo;
item.TelephoneNo = member.TelephoneNo;
item.Occupation = member.Occupation;
item.Birthday = member.Birthday;
item.BirthPlace = member.BirthPlace;
item.Citizenship = member.Citizenship;
item.Gender = member.Gender;
item.MaritalStatus = member.MaritalStatus;
item.PresentAddress = member.PresentAddress;
item.ProvincialAddress = member.ProvincialAddress;
item.ParentId = member.ParentId;
item.SponsorId = member.SponsorId;
item.PaymentType = member.PaymentType;
item.CashNote = member.CashNote;
item.BankBranch = member.BankBranch;
item.DepositNo = member.DepositNo;
item.DateDeposited = member.DateDeposited;
if (!string.IsNullOrEmpty(hCode))
{
item.HierarchyCode = hCode;
}
item.RoleId = member.RoleId;
item.IsFreeAccount = member.IsFreeAccount;
if (member.Picture != null)
{
item.Picture = member.Picture;
}
if (item.MemberId == 0)
{
item.MemberCode = String.Format("M-{0:D8}", lastId + 1);
item.Password = member.Password;
item.Type = MemberTypeEnum.ForValidate.ToString();
item.CreatedDate = DateHelper.DateTimeNow;
item.CreatedBy = currUser;
item.DateJoined = DateHelper.DateTimeNow;
item.RecState = "A";
db.Members.Add(item);
}
else
{
item.ModifiedBy = currUser;
item.ModifiedDate = DateHelper.DateTimeNow;
}
db.SaveChanges();
memberId = item.MemberId;
}
}
}
return(memberId);
}