protected void btnLuu_Click(object sender, EventArgs e) { try { QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); int ID = int.Parse(txtID.Text); Multimedia obj = db.Multimedia.FirstOrDefault(x => x.ID == ID); obj.ID = Convert.ToInt32(txtID.Text); obj.Alt = txtAlt.Text; obj.MaHangHoa = cmbMaHangHoa.SelectedValue; db.SaveChanges(); //Upload file về sever string filename = ""; if (fuAnhHH.HasFile) { string ext = Path.GetFileName(fuAnhHH.FileName); ext = ext.Split('.')[ext.Split('.').Length - 1]; // Tự sinh tên file đảm bảo tính duy nhất => Dùng thời gian upload file để sinh tên file filename = DateTime.Now.ToString("yyyyMMddhhmmssffff") + "." + ext; fuAnhHH.SaveAs(Server.MapPath("~/UpLoads/") + filename); Multimedia newobj = new Multimedia(); newobj.MaHangHoa = obj.MaHangHoa; newobj.Url = filename; db.Multimedia.Add(newobj); db.SaveChanges(); } Response.Redirect("QLAnhHH.aspx"); } catch { pnError.Visible = true; } }
protected void btnThemMoi_Click(object sender, EventArgs e) { try { //Trường hợp thêm mới CTHoaDonBan obj = new CTHoaDonBan(); obj.MaCTHDBan = txtMaCTHDBan.Text; obj.MaHangHoa = cmbMaHangHoa.SelectedValue; obj.SoLuong = Convert.ToInt32(txtSoLuong.Text); obj.DonGia = Convert.ToInt32(txtDonGia.Text); obj.MaCTKM = cmbMaCTKM.SelectedValue; obj.MaHoaDonBan = cmbMaHoaDonBan.SelectedValue; //lưu dữ liệu vào db QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); db.CTHoaDonBan.Add(obj); db.SaveChanges(); Response.Redirect("QLChiTietHDB.aspx"); } catch { pnError.Visible = true; } }
protected void btnThemMoi_Click(object sender, EventArgs e) { try { //Trường hợp thêm mới CauHinh obj = new CauHinh(); obj.ID = txtMaCauHinh.Text; obj.TenCongTy = txtTenCongTy.Text; obj.DiaChiCongTy = txtDiaChiCongTy.Text; obj.SoDienThoai = txtSoDienThoai.Text; obj.MaSoThue = txtMaSoThue.Text; obj.VAT = Convert.ToInt32(txtVAT.Text); //lưu dữ liệu vào db QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); db.CauHinh.Add(obj); db.SaveChanges(); Response.Redirect("QLCauHinh.aspx"); } catch { pnError.Visible = true; } }
protected void btnThemMoi_Click(object sender, EventArgs e) { try { //Trường hợp thêm mới KhachHang obj = new KhachHang(); obj.MaKhachHang = txtMaKhachHang.Text; obj.TenKhachHang = txtTenKhachHang.Text; obj.SoDienThoai = txtSoDienThoai.Text; obj.Gmail = txtGmail.Text; obj.GioiTinh = txtGioiTinh.Text; obj.MatKhau = txtMatKhau.Text; //lưu dữ liệu vào db QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); db.KhachHang.Add(obj); db.SaveChanges(); Response.Redirect("TrangChu.aspx"); } catch { pnError.Visible = true; } }
protected void btnThemMoi_Click(object sender, EventArgs e) { try { //Trường hợp thêm mới HangHoa obj = new HangHoa(); obj.MaHangHoa = txtMaHangHoa.Text; obj.TenHangHoa = txtTenHangHoa.Text; obj.SoLuongTon = Convert.ToInt32(txtSoLuongTon.Text); obj.DonGia = Convert.ToInt32(txtDonGia.Text); obj.DonViTinh = txtDonViTinh.Text; obj.MaLoai = Convert.ToInt32(cmbMaLoai.SelectedValue); obj.MoTa = txtMoTa.Text; //lưu dữ liệu vào db QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); db.HangHoa.Add(obj); db.SaveChanges(); //Upload file về sever string filename = ""; if (fuAnhHH.HasFile) { string ext = Path.GetFileName(fuAnhHH.FileName); ext = ext.Split('.')[ext.Split('.').Length - 1]; // Tự sinh tên file đảm bảo tính duy nhất => Dùng thời gian upload file để sinh tên file filename = DateTime.Now.ToString("yyyyMMddhhmmssffff") + "." + ext; fuAnhHH.SaveAs(Server.MapPath("~/UpLoads/") + filename); Multimedia newobj = new Multimedia(); newobj.MaHangHoa = obj.MaHangHoa; newobj.Alt = obj.TenHangHoa; newobj.Url = filename; db.Multimedia.Add(newobj); db.SaveChanges(); } Response.Redirect("QLHangHoa.aspx"); } catch { pnError.Visible = true; } }
protected void btnXoa_Command(object sender, CommandEventArgs e) { //code de xoa du lieu voi ma lop nien che luu trong commandArgument string MaCTKM = e.CommandArgument.ToString(); //xoa du lieu trong database //tao doi tuong truy van QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); CTKM data = db.CTKM.FirstOrDefault(x => x.MaCTKM == MaCTKM); if (data != null) { db.CTKM.Remove(data); db.SaveChanges(); getData(); } }
protected void btnXoa_Command(object sender, CommandEventArgs e) { //code de xoa du lieu voi ma lop nien che luu trong commandArgument int ID = Convert.ToInt32(e.CommandArgument.ToString()); //xoa du lieu trong database //tao doi tuong truy van QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); Multimedia data = db.Multimedia.FirstOrDefault(x => x.ID == ID); if (data != null) { db.Multimedia.Remove(data); db.SaveChanges(); getData(); } }
protected void btnLuu_Click(object sender, EventArgs e) { try { QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); string MaCTKM = txtMaCTKM.Text; CTKM obj = db.CTKM.FirstOrDefault(x => x.MaCTKM == MaCTKM); obj.MaCTKM = txtMaCTKM.Text; obj.TenCTKM = txtTenCTKM.Text; obj.GiaTriKM = Convert.ToInt32(txtGiaTriKM.Text); obj.LoaiKM = Convert.ToInt32(txtLoaiKM.Text); db.SaveChanges(); Response.Redirect("QLCTKM.aspx"); } catch { pnError.Visible = true; } }
protected void btnThemMoi_Click(object sender, EventArgs e) { try { //Trường hợp thêm mới CTKM obj = new CTKM(); obj.MaCTKM = txtMaCTKM.Text; obj.TenCTKM = txtTenCTKM.Text; obj.GiaTriKM = Convert.ToInt32(txtGiaTriKM.Text); obj.LoaiKM = Convert.ToInt32(txtLoaiKM.Text); QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); db.CTKM.Add(obj); db.SaveChanges(); Response.Redirect("QLCTKM.aspx"); } catch { pnError.Visible = true; } }
protected void btnLuu_Click(object sender, EventArgs e) { try { QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); string MaNhanVien = txtMaNhanVien.Text; NhanVien obj = db.NhanVien.FirstOrDefault(x => x.MaNhanVien == MaNhanVien); obj.MaNhanVien = txtMaNhanVien.Text; obj.TenNhanVien = txtTenNhanVien.Text; obj.MatKhau = txtMatKhau.Text; obj.SoDienThoai = txtSoDienThoai.Text; db.SaveChanges(); Response.Redirect("QLNhanVien.aspx"); } catch { pnError.Visible = true; } }
protected void btnLuu_Click(object sender, EventArgs e) { try { QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); string MaHoaDonNhap = txtMaHoaDonNhap.Text; HoaDonNhap obj = db.HoaDonNhap.FirstOrDefault(x => x.MaHoaDonNhap == MaHoaDonNhap); obj.MaHoaDonNhap = txtMaHoaDonNhap.Text; obj.NgayNhap = Convert.ToDateTime(txtNgayNhap.Text); obj.MaNhanVien = cmbMaNhanVien.SelectedValue; obj.TongGiaTri = Convert.ToInt32(txtTongGiaTri.Text); obj.MaNguonHang = cmbMaNguonHang.SelectedValue; db.SaveChanges(); Response.Redirect("QLPhieuNhap.aspx"); } catch { pnError.Visible = true; } }
protected void btnThemMoi_Click(object sender, EventArgs e) { try { //Trường hợp thêm mới NhanVien obj = new NhanVien(); obj.MaNhanVien = txtMaNhanVien.Text; obj.TenNhanVien = txtTenNhanVien.Text; obj.MatKhau = txtMatKhau.Text; obj.SoDienThoai = txtSoDienThoai.Text; //lưu dữ liệu vào db QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); db.NhanVien.Add(obj); db.SaveChanges(); Response.Redirect("QLNhanVien.aspx"); } catch { pnError.Visible = true; } }
protected void btnLuu_Click(object sender, EventArgs e) { try { QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); string MaCTHDNhap = txtMaCTHDNhap.Text; CTHoaDonNhap obj = db.CTHoaDonNhap.FirstOrDefault(x => x.MaCTHDNhap == MaCTHDNhap); obj.MaCTHDNhap = txtMaCTHDNhap.Text; obj.MaHangHoa = cmbMaHangHoa.SelectedValue; obj.SoLuong = Convert.ToInt32(txtSoLuong.Text); obj.DonGiaNhap = Convert.ToInt32(txtDonGiaNhap.Text); obj.MaHoaDonNhap = cmbMaHoaDonNhap.SelectedValue; db.SaveChanges(); Response.Redirect("QLCTPhieuNhap.aspx"); } catch { pnError.Visible = true; } }
protected void btnLuu_Click(object sender, EventArgs e) { try { QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); string MaHoaDonBan = txtMaHoaDonBan.Text; HoaDonBan obj = db.HoaDonBan.FirstOrDefault(x => x.MaHoaDonBan == MaHoaDonBan); obj.MaHoaDonBan = txtMaHoaDonBan.Text; obj.MaNhanVien = cmbMaNhanVien.SelectedValue; obj.MaKhachHang = cmbMaKhachHang.SelectedValue; obj.NgayBan = Convert.ToDateTime(txtNgayBan.Text); obj.MaCTKM = cmbMaCTKM.SelectedValue; db.SaveChanges(); Response.Redirect("QLHoaDonBan.aspx"); } catch { pnError.Visible = true; } }
protected void btnLuu_Click(object sender, EventArgs e) { try { QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); string ID = txtMaCauHinh.Text; CauHinh obj = db.CauHinh.FirstOrDefault(x => x.ID == ID); obj.ID = txtMaCauHinh.Text; obj.TenCongTy = txtTenCongTy.Text; obj.DiaChiCongTy = txtDiaChiCongTy.Text; obj.SoDienThoai = txtSoDienThoai.Text; obj.MaSoThue = txtMaSoThue.Text; obj.VAT = Convert.ToInt32(txtVAT.Text); db.SaveChanges(); Response.Redirect("QLCauHinh.aspx"); } catch { pnError.Visible = true; } }
protected void btnLuu_Click(object sender, EventArgs e) { try { QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); string MaKhachHang = txtMaKhachHang.Text; KhachHang obj = db.KhachHang.FirstOrDefault(x => x.MaKhachHang == MaKhachHang); obj.MaKhachHang = txtMaKhachHang.Text; obj.TenKhachHang = txtTenKhachHang.Text; obj.SoDienThoai = txtSoDienThoai.Text; obj.Gmail = txtGmail.Text; obj.GioiTinh = txtGioiTinh.Text; obj.LoaiKH = Convert.ToInt32(txtLoaiKH.Text); obj.MatKhau = txtMatKhau.Text; db.SaveChanges(); Response.Redirect("QLKhachHang.aspx"); } catch { pnError.Visible = true; } }
protected void btnThemMoi_Click(object sender, EventArgs e) { try { //Trường hợp thêm mới HoaDonNhap obj = new HoaDonNhap(); obj.MaHoaDonNhap = txtMaHoaDonNhap.Text; obj.NgayNhap = Convert.ToDateTime(txtNgayNhap.Text); obj.MaNhanVien = cmbMaNhanVien.SelectedValue; obj.TongGiaTri = Convert.ToInt32(txtTongGiaTri.Text); obj.MaNguonHang = cmbMaNguonHang.SelectedValue; //lưu dữ liệu vào db QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); db.HoaDonNhap.Add(obj); db.SaveChanges(); Response.Redirect("QLPhieuNhap.aspx"); } catch { pnError.Visible = true; } }
protected void btnThemMoi_Click(object sender, EventArgs e) { try { //Trường hợp thêm mới HoaDonBan obj = new HoaDonBan(); obj.MaHoaDonBan = txtMaHoaDonBan.Text; obj.MaNhanVien = cmbMaNhanVien.SelectedValue; obj.MaKhachHang = cmbMaKhachHang.SelectedValue; obj.NgayBan = Convert.ToDateTime(txtNgayBan.Text); obj.MaCTKM = cmbMaCTKM.SelectedValue; //lưu dữ liệu vào db QLBH_D12TMDTEntities1 db = new QLBH_D12TMDTEntities1(); db.HoaDonBan.Add(obj); db.SaveChanges(); Response.Redirect("QLHoaDonBan.aspx"); } catch { pnError.Visible = true; } }