public bool signUp(Models.DataClassesDataContext data, string email, string password , string fullname, string phone, string address , DateTime birthday, Constants.Gender gender) { bool doesAccountToAddExist = checkThisMemberAccountExist(data, email, password); if (!doesAccountToAddExist) { Models.tbl_member account = new Models.tbl_member(); account.email = email; account.address = address; account.date_added = DateTime.Now; account.last_modified = DateTime.Now; account.name = fullname; account.password = password; account.status = (byte)Constants.AccountStatus.INACTIVE; account.birthday = birthday; account.gender = (byte)gender; account.phone = phone; data.tbl_members.InsertOnSubmit(account); data.SubmitChanges(); //Send email to activate account EmailHelper.getInstance().sendActivatingMail(email); return(true); } return(false); }
public bool activateMemberAccount(BaseController context, string email) { Models.tbl_member memberAccount = getMemberAccountByEmail(context.data, email); if (memberAccount.status != (int)Constants.AccountStatus.ACTIVE) { memberAccount.status = (int)Constants.AccountStatus.ACTIVE; context.updateModel(memberAccount); context.data.SubmitChanges(); return(true); } return(false); }
public void saveOrder(BaseController context, string emailReceiver, string nameReceiver, string phoneReceiver, string addressReceiver, string note, string curency) { //Get member account by session email string emailSender = AccountHelper.getInstance().getLoggingInMemberEmail(context.HttpContext); Models.tbl_member member = AccountHelper.getInstance().getMemberAccountByEmail(context.data, emailSender); //Get shoppingCard in Sesion List <Models.tbl_order_detail> listShoppingCard = getShoppingCardInSession(context); int totalAmount = 0; foreach (Models.tbl_order_detail record in listShoppingCard.ToList()) { totalAmount += record.quantity.Value; } //Save order Models.tbl_order order = new Models.tbl_order(); order.id_customer = member.id; order.total_amount = totalAmount; order.last_modified = DateTime.Now; order.date_added = DateTime.Now; order.email_receiver = emailReceiver; order.email_customer = emailSender; order.name_receiver = nameReceiver; order.name_customer = member.name; order.phone_receiver = phoneReceiver; order.phone_customer = member.phone; order.address_receiver = addressReceiver; order.address_customer = member.address; order.note = note; order.curency = (byte)(curency.Equals("USD") ? 1 : 0); order.status = (int)Constants.OrderStatus.UNPAID; context.data.tbl_orders.InsertOnSubmit(order); context.data.SubmitChanges(); //Submit change here to get the id of inserted record. //Save order_details foreach (Models.tbl_order_detail record in listShoppingCard.ToList()) { record.id_order = order.id; context.data.tbl_order_details.InsertOnSubmit(record); } context.data.SubmitChanges(); }
public Models.tbl_member getMemberAccountByEmail(Models.DataClassesDataContext data, string email) { Models.tbl_member result = data.tbl_members.Where(n => n.email.Equals(email)).Single(); return(result); }