public void CountCartQuantity(int pdid, int mid, int cc) { var sure = db.Product_Detail.Where(x => x.pd_id == pdid).FirstOrDefault(); //紀錄購物車產品數量 var pp = db.Shopping_Cart.Where(x => x.pd_id == pdid).Where(i => i.m_id == mid).FirstOrDefault(); if (cc > 0) { if (sure.pd_stock > sure.pd_onorder)//確認是否有庫存 { sure.pd_onorder++; pp.cart_quantity++; pdid = 0; db.SaveChanges(); } //否則跳出 顯示已沒庫存 } if (cc < 0) { if (pp.cart_quantity > 1) { sure.pd_onorder--; pp.cart_quantity--; db.SaveChanges(); } } }
public ActionResult Registration(RegisterViewModel m) { //gmail的資料 Guid GmailId = Guid.NewGuid(); Session["regis-user"] = m.UserName; Random rd = new Random(); //random值 發認證信 var code = rd.Next(100000, 999999); if (!ModelState.IsValid) { return(View(m)); } Member user = db.Member.Where(x => x.m_email == m.Email).FirstOrDefault(); //user 已經存在 if (user != null) { ModelState.AddModelError("", "The email is invalid."); return(View()); } //新增進資料庫 else { Member memb = new Member() { m_name = m.UserName, m_email = m.Email, m_password = m.Password, m_status = "0", m_verification = code.ToString(), m_email_id = GmailId }; db.Member.Add(memb); db.SaveChanges(); Session["memb_id"] = memb.m_id; //寄信給對方 確認信箱有效 var email = db.Member.Where(x => x.m_id == memb.m_id).FirstOrDefault().m_email; //收信人的email System.Net.Mail.MailMessage MyMail = new System.Net.Mail.MailMessage(); //建立MAIL MyMail.From = new System.Net.Mail.MailAddress("*****@*****.**", "GuruTw"); //寄信人 MyMail.To.Add(new System.Net.Mail.MailAddress(email)); //收信人1 MyMail.Subject = "Welcome to Guru. Please verify your account to become Guru's member."; //主題 MyMail.Body = "Hello,\n\n Thank you for your registration\n\n This is your account verification code \n\n" + code + "\n\n Best Regards,\n\n GuruTW"; //內容 System.Net.Mail.SmtpClient Client = new System.Net.Mail.SmtpClient("smtp.gmail.com", 587); //GMAIL主機 //System.Net.Mail.SmtpClient Client = new System.Net.Mail.SmtpClient("msa.hinet.net");//hinet主機 Client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "wearethe@1"); //帳密,Hinet不用但須在它的ADLS(區段)裡面 Client.EnableSsl = true; //Gmail需啟動SSL,Hinet不用 Client.Send(MyMail); //寄出 return(View("VerifyRegistration")); } }
public ActionResult OrderDeliver([Bind(Include = "o_receiver,o_address,pay_id,dw_id")] Order or) { var user = int.Parse(Session["m_id"].ToString()); //Order or = new Order(); if (ModelState.IsValid) { or.m_id = user; or.o_status = "0"; or.o_date = DateTime.Now; db.Order.Add(or); db.SaveChanges(); return(RedirectToAction("CreateOrderDetail", new { id = or.o_id })); } return(View(or)); }