public bool KhachHang_Insert(Entity.KhachHang Data)
{
try
{
using (SqlCommand dbCmd = new SqlCommand("sp_KhachHang_Insert", GetConnection()))
{
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@tenKH", Data.TenKH));
dbCmd.Parameters.Add(new SqlParameter("@GioiTinh", Data.GioiTinh));
dbCmd.Parameters.Add(new SqlParameter("@NgaySinh", Data.NgaySinh));
dbCmd.Parameters.Add(new SqlParameter("@TaiKhoan", Data.TaiKhoan));
dbCmd.Parameters.Add(new SqlParameter("@MatKhau", Data.MatKhau));
dbCmd.Parameters.Add(new SqlParameter("@Email", Data.Email));
dbCmd.Parameters.Add(new SqlParameter("@SDT", Data.SDT));
dbCmd.Parameters.Add(new SqlParameter("@Tinh", Data.Tinh));
dbCmd.Parameters.Add(new SqlParameter("@Quan", Data.Quan));
dbCmd.Parameters.Add(new SqlParameter("@DiaChi", Data.DiaChi));
dbCmd.Parameters.Add(new SqlParameter("@Link_Fb", Data.Link_Fb));
//dbCmd.Parameters.Add(new SqlParameter("@HinhThucThanhToan", Data.HinhThucThanhToan));
dbCmd.ExecuteNonQuery();
}
//Clear cache
System.Web.HttpContext.Current.Cache.Remove("KhachHang");
return(true);
}
catch
{
return(false);
}
}
public List <KhachHang> KhachHang_GetByTop(string Top, string Where, string Order)
{
List <Entity.KhachHang> list = new List <Entity.KhachHang>();
using (SqlCommand dbCmd = new SqlCommand("sp_KhachHang_GetByTop", GetConnection()))
{
Entity.KhachHang obj = new Entity.KhachHang();
dbCmd.CommandType = CommandType.StoredProcedure;
dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
SqlDataReader dr = dbCmd.ExecuteReader();
dr.Close();
dr = dbCmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
list.Add(obj.KhachHangIDataReader(dr));
}
}
dr.Close();
obj = null;
}
return(list);
}
public Entity.KhachHang KhachHangIDataReader(IDataReader dr)
{
Entity.KhachHang obj = new Entity.KhachHang();
obj.Id = (dr["Id"] is DBNull) ? string.Empty : dr["Id"].ToString();
obj.TenKH = (dr["TenKH"] is DBNull) ? string.Empty : dr["TenKH"].ToString();
obj.GioiTinh = (dr["GioiTinh"] is DBNull) ? string.Empty : dr["GioiTinh"].ToString();
obj.NgaySinh = (dr["NgaySinh"] is DBNull) ? string.Empty : dr["NgaySinh"].ToString();
obj.TaiKhoan = (dr["TaiKhoan"] is DBNull) ? string.Empty : dr["TaiKhoan"].ToString();
obj.MatKhau = (dr["MatKhau"] is DBNull) ? string.Empty : dr["MatKhau"].ToString();
obj.Email = (dr["Email"] is DBNull) ? string.Empty : dr["Email"].ToString();
obj.SDT = (dr["SDT"] is DBNull) ? string.Empty : dr["SDT"].ToString();
obj.Tinh = (dr["Tinh"] is DBNull) ? string.Empty : dr["Tinh"].ToString();
obj.Quan = (dr["Quan"] is DBNull) ? string.Empty : dr["Quan"].ToString();
obj.DiaChi = (dr["DiaChi"] is DBNull) ? string.Empty : dr["DiaChi"].ToString();
obj.TinhTrang = (dr["TinhTrang"] is DBNull) ? string.Empty : dr["TinhTrang"].ToString();
obj.Link_Fb = (dr["Link_Fb"] is DBNull) ? string.Empty : dr["Link_Fb"].ToString();
return(obj);
}
private void tsslblghilai_Click(object sender, EventArgs e)
{
if (Kiemtra())
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entity.KhachHang nv = new Entity.KhachHang();
nv = new Entity.KhachHang("Update", int.Parse(id), txtmakh.Text, txthoten.Text, cbxnhomkh.Text, txtdiachi.Text, txtdt.Text, txtfax.Text, txtemail.Text, txtmasothue.Text,
0, (float)System.Convert.ToInt32(txthanmucthanhtoan.Text), txtcongty.Text, DateTime.Now, System.Convert.ToInt32(txtmavung.Text),
txtMobile.Text, DateTime.Now, DateTime.Now, ckbngungtheodoi.Checked, txtwebsite.Text, DateTime.Now, txtghichu.Text, false);
clientstrem = cl.SerializeObj(this.client1, "KhachHang", nv);
int msg = 0;
msg = (int)cl.DeserializeHepper(clientstrem, msg);
if (msg == 1)
{
MessageBox.Show("Update thanh cong ...");
frm.SelectData();
}
else
{
MessageBox.Show("Update that bai");
}
}
}
public static bool KhachHang_UpdateDatHang(Entity.KhachHang data)
{
return(cmb.KhachHang_UpdateDatHang(data));
}
public static bool KhachHang_Insert(Entity.KhachHang data)
{
return(cmb.KhachHang_Insert(data));
}
protected void btndathang_Click(object sender, EventArgs e)
{
List <Entity.KhachHang> lstKh = new List <Entity.KhachHang>();
Entity.DatHang dh = new Entity.DatHang();
List <Entity.DatHang> lstdh = new List <Entity.DatHang>();
Entity.ChiTietDatHang lstctdh = new Entity.ChiTietDatHang();
string Id_SP;
if (txtdiachi.Text == "" || txtdienthoai.Text == "" || txtemail.Text == "" || txthovaten.Text == "") //|| ddlquan.SelectedIndex == 0 || ddlthanhpho.SelectedIndex == 0
{
Response.Write("<script>alert('" + ddlquan.SelectedValue + "')</script>");
Response.Write("<script>alert('Bạn phải nhập đầy đủ thông tin!!1')</script>");
return;
}
else
{
if (Session["TenDangNhap"] == null)
{
Entity.KhachHang obj = new Entity.KhachHang();
//Response.Write("<script>alert('Vào đây')</script>");
obj.TenKH = txthovaten.Text;
obj.TaiKhoan = "";
obj.MatKhau = "";
obj.NgaySinh = "";
obj.GioiTinh = "True";
obj.Email = txtemail.Text;
obj.SDT = txtdienthoai.Text;
obj.DiaChi = txtdiachi.Text;
obj.Tinh = ddlthanhpho.SelectedItem.ToString();
obj.Quan = ddlquan.SelectedItem.ToString();
obj.Link_Fb = "false";
KhachHangService.KhachHang_Insert(obj);
lstKh = KhachHangService.KhachHang_GetByTop("", " id=(SELECT MAX(id) from tbl_KhachHang) ", "");
tbl_DatHang dhs = new tbl_DatHang();
dhs.id_KhachHang = int.Parse(lstKh[0].Id);
dhs.NgaylapHD = DateTime.Now;
dhs.IdPay = int.Parse(ddlhinhthucthanhtoan.SelectedValue);
///////////////////////////////////////////////////////////////////
dbs.tbl_DatHangs.InsertOnSubmit(dhs);
dbs.SubmitChanges();
lstdh = DatHangService.DatHang_GetByTop("", " id=(SELECT MAX(id) from tbl_DatHang)", "");
lstctdh.Id_hoadon = lstdh[0].Id;
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
lstctdh.Id_hang = Id_SP;
lstctdh.Size = tbGioHang.Rows[i]["Size"].ToString();
lstctdh.SoLuongMua = tbGioHang.Rows[i]["SoLuong"].ToString();
lstctdh.ThanhTien = tbGioHang.Rows[i]["TongGia"].ToString();
lstctdh.Gia = tbGioHang.Rows[i]["Gia"].ToString();
ChiTietDatHangService.ChiTietDatHang_Insert(lstctdh);
}
}
else
{
string TenDangNhap = Session["TenDangNhap"].ToString();
lstKh = KhachHangService.KhachHang_GetByTop("", " TaiKhoan='" + TenDangNhap + "'", "");
Entity.KhachHang kh = new Entity.KhachHang();
kh.Id = lstKh[0].Id;
kh.TenKH = txthovaten.Text;
kh.Email = txtemail.Text;
kh.DiaChi = txtdiachi.Text;
kh.SDT = txtdienthoai.Text;
kh.Tinh = ddlthanhpho.SelectedItem.ToString();
kh.Quan = ddlquan.SelectedItem.ToString();
KhachHangService.KhachHang_UpdateDatHang(kh);
tbl_DatHang dhs = new tbl_DatHang();
dhs.id_KhachHang = int.Parse(kh.Id);
dhs.NgaylapHD = DateTime.Now;
dhs.IdPay = int.Parse(ddlhinhthucthanhtoan.SelectedValue);
///////////////////////////////////////////////////////////////////
dbs.tbl_DatHangs.InsertOnSubmit(dhs);
dbs.SubmitChanges();
lstdh = DatHangService.DatHang_GetByTop("", " id=(SELECT MAX(id) from tbl_DatHang where id_KhachHang=" + kh.Id + ")", "");
lstctdh.Id_hoadon = lstdh[0].Id;
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
lstctdh.Id_hang = Id_SP;
lstctdh.Size = tbGioHang.Rows[i]["Size"].ToString();
lstctdh.SoLuongMua = tbGioHang.Rows[i]["SoLuong"].ToString();
lstctdh.ThanhTien = tbGioHang.Rows[i]["TongGia"].ToString();
lstctdh.Gia = tbGioHang.Rows[i]["Gia"].ToString();
ChiTietDatHangService.ChiTietDatHang_Insert(lstctdh);
}
}
}
Response.Write("<script>alert('Đặt hàng thành công!! Cảm ơn bạn nhiều nhé!! ')</script>");
// MailMessage message = new MailMessage("*****@*****.**",txtemail.Text, "Shop Fashion(Clothing Store) ",grvsanpham.Rows[0].Cells[0].Text);
// message.IsBodyHtml = true;
// SmtpClient client = new SmtpClient("smtp.gmail.com", 587);
//client.EnableSsl = true;
//client.UseDefaultCredentials = false;
//client.DeliveryMethod = SmtpDeliveryMethod.Network;
//client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Baonguyen741999@!");
//client.Send(message);
for (int i = 0; i < tbGioHang.Rows.Count; i++)
{
var from = "*****@*****.**";
var to = txtemail.Text;
const string Password = "******";
string mail_subject = "Clothing Store";
string mail_message = "From : Clothing Store" + "\n";
mail_message += "From : [email protected] " + "\n";
mail_message += "Thông tin mua hàng của quý khách" + "\n";
string tenSP = tbGioHang.Rows[i]["TenSP"].ToString();
Id_SP = SanPhamService.SanPham_GetByTop("", " TenHang=N'" + tenSP + "'", "")[0].Id;
mail_message += "ID sản phẩm : " + Id_SP + "\n";
mail_message += "Tên sản phẩm :" + tbGioHang.Rows[i]["TenSP"].ToString() + "\n";
mail_message += "Size: " + tbGioHang.Rows[i]["Size"].ToString() + "\n";
mail_message += "Số lượng: " + tbGioHang.Rows[i]["SoLuong"].ToString() + "\n";
mail_message += "Tổng giá: " + tbGioHang.Rows[i]["TongGia"].ToString() + "\n";
mail_message += "Giá: " + tbGioHang.Rows[i]["Gia"].ToString() + "\n";
var smtp = new SmtpClient();
{
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
smtp.Credentials = new NetworkCredential(from, Password);
smtp.Timeout = 10000;
}
smtp.Send(from, to, mail_subject, mail_message);
}
Session["GioHang"] = null;
Session["slspgiohang"] = null;
lblsl = (Label)Master.FindControl("lblslgiohang");
lblsl.Text = "0";
lbltongtien.Text = "0 VNĐ";
tbGioHang = null;
grvsanpham.DataSource = tbGioHang;
grvsanpham.DataBind();
Response.AddHeader("REFRESH", "1;URL=TrangChu.aspx");
}
private void tsslblthemmoi_Click(object sender, EventArgs e)
{
if (Kiemtra())
{
Server_Client.Client cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entity.KhachHang nv = new Entity.KhachHang();
nv = new Entity.KhachHang("Insert",int.Parse(id),txtmakh.Text,txthoten.Text,cbxnhomkh.Text,txtdiachi.Text,txtdt.Text,txtfax.Text,txtemail.Text,txtmasothue.Text,
0, 0, txtcongty.Text, DateTime.Now, int.Parse(txtmavung.Text),
txtMobile.Text, DateTime.Now, DateTime.Now, ckbngungtheodoi.Checked, txtwebsite.Text, DateTime.Now, txtghichu.Text, false);
clientstrem = cl.SerializeObj(this.client1, "KhachHang", nv);
int msg = 0;
msg = (int)cl.DeserializeHepper(clientstrem, msg);
if (msg == 1)
{
MessageBox.Show("Insert thanh cong ...");
frm.SelectData();
}
else
MessageBox.Show("Insert that bai");
}
}