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