private void btnLuu_Click(object sender, EventArgs e)
{
if (check == null)
{
KhoHang akh = new KhoHang()
{
MaKho = txtMaKho.Text,
TenKho = txtTenKho.Text,
LienHe = txtLienHe.Text,
GhiChu = txtGhiChu.Text,
DienThoai = txtDienThoai.Text
//ConQuanLy= ckQuanLy.Checked
};
if (kh_bus.ThemKhoHang(akh) > 0)
{
MessageBox.Show("Thêm thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
KhoHang akh = new KhoHang()
{
MaKho = txtMaKho.Text,
TenKho = txtTenKho.Text,
LienHe = txtLienHe.Text,
GhiChu = txtGhiChu.Text,
DienThoai = txtDienThoai.Text
};
if (kh_bus.Update(akh) > 0)
{
MessageBox.Show("Cập nhật thành công.", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public async Task <IActionResult> Edit(int id, [Bind("KhoHangId,SoLuong,HangHoaId")] KhoHang khoHang)
{
if (id != khoHang.KhoHangId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(khoHang);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!KhoHangExists(khoHang.KhoHangId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["HangHoaId"] = new SelectList(_context.HangHoa, "HangHoaId", "Hinh", khoHang.HangHoaId);
return(View(khoHang));
}
private void listenData()
{
KhoHang.connect(ip);
KhoHang.socket.On("getData", (data) =>
{
StreamWriter sourceStream = new StreamWriter("../../../Resources/input.txt");
sourceStream.Write(data.ToString());
sourceStream.Close();
khoHang.loadData();
this.Dispatcher.Invoke(() =>
{
foreach (var lv1 in buttonList)
{
foreach (var lv2 in lv1)
{
foreach (KButton k in lv2)
{
if (k.Background != Brushes.LightBlue)
{
k.updateBackGround();
}
}
}
}
drawArea.InvalidateVisual();
});
});
}
public List <KhoHang> HienThiKhoHangTheoTen(string TenKhoHang)
{
try
{
List <KhoHang> DanhSachKhoHang = new List <KhoHang>();
OpenDataBase();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "TimKiemKhoHangTheoTen";
sqlCommand.Parameters.Add("@TenKhoHang", SqlDbType.NVarChar).Value = TenKhoHang;
sqlCommand.Connection = sqlConnection;
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
KhoHang khoHang = new KhoHang()
{
MaKhoHang = sqlDataReader.GetString(0),
TenKhoHang = sqlDataReader.GetString(1),
DiaChi = sqlDataReader.GetString(2),
SoDienThoai = sqlDataReader.GetString(3)
};
DanhSachKhoHang.Add(khoHang);
}
sqlDataReader.Close();
return(DanhSachKhoHang);
}
catch (Exception ex)
{
throw ex;
}
}
public MainWindow()
{
#region initialize
// Khởi tạo các tham số ứng dụng
InitializeComponent();
st = new Setting(this);
Title = title;
Icon = BitmapFrame.Create(new BitmapImage(iconUri));
#endregion
#region timerStart
// Bắt đầu bộ đếm giờ
dispatcherTimer.Tick += new EventHandler(dispatcherTimer_Tick);
dispatcherTimer.Interval = new TimeSpan(0, 0, refreshTime);
dispatcherTimer.Start();
#endregion
#region captureMouseOnTextBox
// Theo dõi chuột trên Textbox
startPos.GotMouseCapture += StartPos_GotMouseCapture;
endPos.GotMouseCapture += EndPos_GotMouseCapture;
startPos.IsReadOnly = false;
endPos.IsReadOnly = false;
#endregion
#region drawMap
// Download dữ liệu nếu đang trực tuyến và vẽ Kho Hàng
KhoHang.downloadFile();
GenerateMap();
GenerateZoomMenu();
#endregion
}
public ActionResult Create(KhoHang warehouse)
{
if (ModelState.IsValid)
{
ThongBaoMvc thongbao;
warehouse.MaCN = kiemtra.getUser(User.Identity.Name).MaCN;
db.KhoHangs.Add(warehouse);
try {
db.SaveChanges();
thongbao = new ThongBaoMvc {
CssClassName = "success", Message = "Thành công thêm kho hàng mới."
};
TempData["ResultAction"] = thongbao;
return(RedirectToAction("Index"));
}catch (Exception e)
{
log.Error("Lỗi thêm kho hàng mới: " + e.Message);
thongbao = new ThongBaoMvc {
CssClassName = "danger", Message = "Lỗi."
};
TempData["ResultAction"] = thongbao;
}
}
return(View(warehouse));
}
private void btn_ThanhToan_Click(object sender, EventArgs e)
{
try
{
int MaNcc = int.Parse(cbNhaCungCap.SelectedValue.ToString());
int manv = int.Parse(cb_TenNhanVien.SelectedValue.ToString());
DateTime ngaynhap = DateTime.Parse(txt_NgayNhap.Text);
PhieuNhap a = new PhieuNhap();
a.NgayNhap = ngaynhap;
a.MaNV = manv;
a.MaNcc = MaNcc;
a.SoLuong = soluongss;
bool check = PhieuNhapModels.phieunhapCons.themPhieu(a);
if (check == true)
{
foreach (CTPhieuNhap item in listCT)
{
item.MaPhieuNhap = PhieuNhapModels.phieunhapCons.getLastMa();
CTPhieuNhapModels.CTPhieuNhapCons.themCT(item);
}
int mapn = PhieuNhapModels.phieunhapCons.getLastMa();
KhoHang kh = new KhoHang();
kh.MaPhieuNhap = mapn;
kh.NgayNhap = DateTime.Now;
LoHangModels.chucVu.themLoHang(kh);
MessageBox.Show("Thêm phiếu nhập thành công");
pn_ThongTin.Enabled = false;
}
}
catch (Exception)
{
MessageBox.Show("Bạn nhập ngày không đúng yêu cầu ");
}
}
public IHttpActionResult PutKhoHang(string id, KhoHang khoHang)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != khoHang.IDNK)
{
return(BadRequest());
}
db.Entry(khoHang).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KhoHangExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Put([FromBody] KhoHang khohang)
{
var entity = dbContext.KhoHangs.FirstOrDefault(e => e.ID_ThucPham == khohang.ID_ThucPham);
entity.SoLuong += khohang.SoLuong;
dbContext.SaveChanges();
}
public KhoHang HienThiKhoHangTheoMaNhaVien(string MaNhanVien)
{
//HienThiKhoHangTheoMaNhanVien
try
{
KhoHang khoHang = new KhoHang();
OpenDataBase();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "HienThiKhoHangTheoMaNhanVien";
sqlCommand.Parameters.Add("@MaNhanVien", SqlDbType.Char).Value = MaNhanVien;
sqlCommand.Connection = sqlConnection;
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
khoHang.MaKhoHang = sqlDataReader.GetString(0);
khoHang.TenKhoHang = sqlDataReader.GetString(1);
khoHang.DiaChi = sqlDataReader.GetString(2);
khoHang.SoDienThoai = sqlDataReader.GetString(3);
}
sqlDataReader.Close();
return(khoHang);
}
catch
{
return(null);
}
}
private void gvDanhSachNhanVien_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
DataGridViewRow dataGridViewRow = gvDanhSachNhanVien.Rows[e.RowIndex];
texMaNhanVien.Text = dataGridViewRow.Cells[0].Value + "";
texTenNhanVien.Text = dataGridViewRow.Cells[1].Value + "";
texCMT.Text = dataGridViewRow.Cells[2].Value + "";
dateNgaySinh.Value = DoiNgay(dataGridViewRow.Cells[3].Value + "");
cbGioiTinh.Text = dataGridViewRow.Cells[4].Value + "";
texDiaChi.Text = dataGridViewRow.Cells[5].Value + "";
texDienThoai.Text = dataGridViewRow.Cells[6].Value + "";
texEmail.Text = dataGridViewRow.Cells[7].Value + "";
cbChucVu.Text = dataGridViewRow.Cells[8].Value + "";
texTienLuong.Text = dataGridViewRow.Cells[9].Value + "";
dateNgayVaoLam.Value = DoiNgay(dataGridViewRow.Cells[10].Value + "");
for (int i = 0; i < cbKhoHang.Items.Count; i++)
{
KhoHang khoHang = cbKhoHang.Items[i] as KhoHang;
if (khoHang.TenKhoHang == dataGridViewRow.Cells[11].Value + "")
{
cbKhoHang.SelectedItem = khoHang;
break;
}
}
}
}
public List <KhoHang> LayToanBoKhoHang()
{
try
{
List <KhoHang> DanhSachKhoHang = new List <KhoHang>();
OpenDataBase();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "HienThiDanhSachKhoHang";
sqlCommand.Connection = sqlConnection;
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
KhoHang khoHang = new KhoHang()
{
MaKhoHang = sqlDataReader.GetString(0),
TenKhoHang = sqlDataReader.GetString(1),
DiaChi = sqlDataReader.GetString(2),
SoDienThoai = sqlDataReader.GetString(3)
};
DanhSachKhoHang.Add(khoHang);
}
sqlDataReader.Close();
return(DanhSachKhoHang);
}
catch (Exception ex)
{
throw ex;
}
}
public UcKhoHang(long defaultSelected, KhoHang data = null)
{
InitializeComponent();
long selectedLoaiHang = -1;
if (data != null)
{
selectedLoaiHang = data.LoaiHangId;
}
KhoHang_LoaiHangId.DisplayMember = "Ten";
KhoHang_LoaiHangId.ValueMember = "Id";
var lstLoaiHang =
CRUD.DbContext.DanhMucs.Where(s => (s.IsActived || s.Id == selectedLoaiHang) &&
s.Loai == Define.LoaiDanhMucEnum.DienThoai.ToString())
.ToList();
KhoHang_LoaiHangId.DataSource = new BindingSource(lstLoaiHang, null);
_domainData = data;
if (_domainData == null)
{
_domainData = new KhoHang();
_domainData.LoaiHangId = defaultSelected;
_domainData.IsActived = true;
}
Init(_domainData);
btnNgungKinhDoanh.Text = _domainData.IsActived ? "Ngưng Kinh Doanh" : "Tiếp Tục Kinh Doanh";
}
public ActionResult Edit(KhoHang warehouse)
{
if (ModelState.IsValid)
{
ThongBaoMvc thongbao;
db.Entry(warehouse).State = EntityState.Modified;
try {
db.SaveChanges();
thongbao = new ThongBaoMvc {
CssClassName = "success", Message = "Thành công thay đổi thông tin kho hàng."
};
TempData["ResultAction"] = thongbao;
return(RedirectToAction("Index"));
}catch (Exception e)
{
thongbao = new ThongBaoMvc {
CssClassName = "danger", Message = "Lỗi."
};
TempData["ResultAction"] = thongbao;
log.Error("Lỗi thay đổi thông tin kho: " + e.Message);
}
}
return(View(warehouse));
}
public ActionResult DeleteConfirmed(string id)
{
KhoHang khoHang = db.KhoHangs.Find(id);
db.KhoHangs.Remove(khoHang);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public int Update(KhoHang kh)
{
string sql =
string.Format("Update KhoHang Set TenKho=N'{0}',LienHe =N'{1}',DienThoai='{2}',GhiChu=N'{3}' where MaKho='{4}'", kh.TenKho, kh.LienHe, kh.DienThoai, kh.GhiChu, kh.MaKho);
var rs = db.ExecuteSQL(sql);
return(rs);
}
private void btnLuu_Click(object sender, EventArgs e)
{
KhoHang kh = ChuyenSangDTO();
XL_HANGHOA.ThemKhoHang(kh);
XtraMessageBox.Show("Lưu thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
public HttpResponseMessage PostGiay(KhoHang kho)
{
var response = Request.CreateResponse <KhoHang>(HttpStatusCode.Created, null);
string uri = Url.Link("DefaultApi", null);
response.Headers.Location = new Uri(uri);
return(response);
}
public int ThemKhoHang(KhoHang kh)
{
string sql = string.Format("insert into [KhoHang] Values('{0}', '{1}', '{2}', '{3}','{4}', '{5}')"
, kh.Ma, kh.Ten, kh.LienHe, kh.DienThoai, kh.GhiChu, kh.ConQuanLy);
var rs = db.ExecuteSQL(sql);
return(rs);
}
public int ThemKhoHang(KhoHang kh)
{
string sql = string.Format("insert into [KhoHang](MaKho,TenKho,LienHe,DienThoai,GhiChu) Values('{0}', N'{1}',N'{2}','{3}',N'{4}')"
, kh.MaKho, kh.TenKho, kh.LienHe, kh.DienThoai, kh.GhiChu);
var rs = db.ExecuteSQL(sql);
return(rs);
}
public JsonResult CreateCT_PNK(string ma_pnk, string ma_hang_s, string ma_kho_s, string so_luong_s, string don_gia_s)
{
bool success = true;
string message = "Kết quả: Hoàn thành việc nhập kho!";
var daoCT = new ChiTietNhapDao();
var daoHH = new HangHoaDao();
var daoKho = new KhoHangDao();
string[] lst_ma_hang = ma_hang_s.Split(',');
string[] lst_so_luong = so_luong_s.Split(',');
string[] lst_don_gia = don_gia_s.Split(',');
string[] lst_ma_kho = ma_kho_s.Split(',');
try
{
for (int i = 0; i < lst_ma_hang.Length; i++)
{
ChiTietNhap obj = new ChiTietNhap();
obj.NhapID = ma_pnk;
obj.MaHH = lst_ma_hang[i].ToString();
obj.SoLuong = int.Parse(lst_so_luong[i].ToString());
obj.DonGia = decimal.Parse(lst_don_gia[i].ToString());
obj.MaKho = int.Parse(lst_ma_kho[i].ToString());
obj.CreatedDate = DateTime.Now;
obj.CreateBy = Session["UserName"].ToString();
obj.TongTien = decimal.Parse(lst_don_gia[i].ToString()) * int.Parse(lst_so_luong[i].ToString());
daoCT.Insert(obj);
daoHH.NhapHang(lst_ma_hang[i].ToString(), int.Parse(lst_so_luong[i].ToString()),
decimal.Parse(lst_don_gia[i].ToString()), Session["UserName"].ToString());
if (daoKho.CheckKho(int.Parse(lst_ma_kho[i].ToString()), lst_ma_hang[i].ToString()))
{
daoKho.NhapThemHang(int.Parse(lst_ma_kho[i].ToString()),
lst_ma_hang[i].ToString(), int.Parse(lst_so_luong[i].ToString()));
}
else
{
KhoHang kho_hang = new KhoHang();
kho_hang.MaKho = int.Parse(lst_ma_kho[i].ToString());
kho_hang.MaHH = lst_ma_hang[i].ToString();
kho_hang.SoLuong = int.Parse(lst_so_luong[i].ToString());
daoKho.Insert(kho_hang);
}
}
}
catch (Exception ex)
{
success = false;
message = "Kết quả: " + ex.ToString() + ".";
}
return(Json(new
{
success = success,
message = message
}));
}
public async Task <ActionResult <KhoHang> > PostKhoHang(KhoHang khohang)
{
ThucPham ThucPham = dbContext.ThucPhams.FirstOrDefault(e => e.ID_ThucPham == khohang.ID_ThucPham);
khohang.TenThucPham = ThucPham.Name;
dbContext.KhoHangs.Add(khohang);
await dbContext.SaveChangesAsync();
return(CreatedAtAction(nameof(Get), new { ID_KhoHang = khohang.ID_KhoHang }, khohang));
}
public bool Check([FromBody] KhoHang khohang)
{
KhoHang trong_kho = dbContext.KhoHangs.FirstOrDefault(e => e.ID_ThucPham == khohang.ID_ThucPham);
if (trong_kho != null)
{
return(true);
}
return(false);
}
// Bộ đếm giờ làm việc
protected void dispatcherTimer_Tick(object sender, EventArgs e)
{
// Nếu đang trực tuyến thì cập nhật
if (isOnline == true && Ftp == true)
{
KhoHang.downloadFile();
khoHang.loadData();
}
RefreshData();
}
public ActionResult Edit([Bind(Include = "MaKho,MaSanPham,TenSanPham,SoLuong")] KhoHang khoHang)
{
if (ModelState.IsValid)
{
db.Entry(khoHang).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(khoHang));
}
private void btnXoaSP_Click(object sender, EventArgs e)
{
KhoHang khoHang = cbKhoHang.SelectedItem as KhoHang;
HienThiSanPhamBLL hienThiSanPhamBLL = new HienThiSanPhamBLL();
int k = 0;
foreach (SanPham Sp in hienThiSanPhamBLL.HienThiDanhSachSanPhamTheoKho(khoHang.MaKhoHang))
{
k++;
if (Sp.MaSanPham.Trim() == texMaSP.Text.Trim())
{
texMaSP.Text = Sp.MaSanPham;
texTenSP.Text = Sp.TenSanPham;
break;
}
if (k == hienThiSanPhamBLL.HienThiDanhSachSanPhamTheoKho(khoHang.MaKhoHang).Count&& Sp.MaSanPham.Trim() != texMaSP.Text.Trim())
{
int h = 0;
foreach (SanPham Sp1 in hienThiSanPhamBLL.HienThiDanhSachSanPham())
{
h++;
if (Sp1.MaSanPham.Trim() == texMaSP.Text.Trim())
{
MessageBox.Show("Sản Phẩm Chưa Tồn Tại Trong Kho Hàng Nhưng Đã Tồn Tại Mã Trong Hệ Thông Bạn Cần Chọn Mã Sản Phẩm Khác");
return;
}
else if (h == hienThiSanPhamBLL.HienThiDanhSachSanPham().Count&& Sp1.MaSanPham.Trim() != texMaSP.Text.Trim())
{
MessageBox.Show("Sản Phẩm Chưa Tồn Tại Trong Kho Mã Sản Phẩm Hợp Lệ");
break;
}
}
}
}
//if(texMaSP.Text== null)
//{
// MessageBox.Show("Ban can Cap Nhap Ma San Pham Truoc Khi Xoa");
// return;
//}
//if(texMaHoaDon.Text == null)
//{
// MessageBox.Show("Ban can Nhap Ma Hoa Don Truoc Khi Xoa");
// return;
//}
//if(cbKhoHang.SelectedItem == null)
//{
// MessageBox.Show("Ban Can Chon Kho Hang Truoc Khi Xoa");
// return;
//}
//KhoHang khoHang = cbKhoHang.SelectedItem as KhoHang;
//HienThiCT_PhieuNhapBLL hienThiCT_PhieuNhapBLL = new HienThiCT_PhieuNhapBLL();
//hienThiCT_PhieuNhapBLL.XoaCt_PhieuNhap(texMaHoaDon.Text, texMaSP.Text, khoHang,int.Parse(texSoLuong.Text));
//HienThiDanhSachSanPhamHD(hienThiCT_PhieuNhapBLL.HienThiDanhSachSPTheoMaPhieu(texMaHoaDon.Text));
}
public IActionResult DatHang(string makh, string hotenkh, string diachikh, string sdt, string tennhan, string sdtnhan, string diachinhan, string ghichunhan)
{
HoaDon hd = new HoaDon
{
MaKh = makh,
HoTen = hotenkh,
DiaChi = diachikh,
DienThoai = sdt,
TenNgNhan = tennhan,
DtngNhan = sdtnhan,
DiaChiNgNhan = diachinhan,
GhiChu = ghichunhan,
NgayDat = DateTime.Now,
MaTrangThai = 0,
PhiVanChuyen = 0
};
db.HoaDon.Add(hd);
foreach (var item in Carts)
{
SanPham hh = db.SanPham.SingleOrDefault(p => p.MaSp == item.MaHh);
//Lưu chi tiết hóa đơn
ChiTietHd cthd = new ChiTietHd
{
MaHd = hd.MaHd,
MaSp = item.MaHh,
DonGia = hh.DonGia,
SoLuong = item.SoLuong,
};
db.ChiTietHd.Add(cthd);
db.SaveChanges();
//Kiểm tra hàng tồn kho
KhoHang kho = db.KhoHang.SingleOrDefault(p => p.MaSp == cthd.MaSp);
if (kho.SoLuong >= cthd.SoLuong)
{
kho.SoLuong = kho.SoLuong - cthd.SoLuong;
db.SaveChanges();
}
else
{
SanPham sp = db.SanPham.SingleOrDefault(p => p.MaSp == cthd.MaSp);
db.ChiTietHd.Remove(cthd);
db.HoaDon.Remove(hd);
db.SaveChanges();
return(RedirectToAction("ThanhToan1"));
}
}
HttpContext.Session.Remove("GioHang");
HttpContext.Session.Remove("ThongTin");
return(RedirectToAction("ThanhToan1"));
}
private void barbtnkhohang_ItemClick(object sender, ItemClickEventArgs e)
{
KhoHang KhoHang = new KhoHang();
if (ExistsForm(KhoHang))
{
return;
}
KhoHang.MdiParent = this;
KhoHang.Show();
}
private void btnChinhSua_Click(object sender, EventArgs e)
{
if (texMaNhanVien.Text == "" || texMaNhanVien.Text == null)
{
MessageBox.Show("Bạn Phải Chọn Nhân Viên Cần Chỉnh Sửa");
return;
}
if (cbGioiTinh.Text == "" || cbGioiTinh.Text == null)
{
MessageBox.Show("Bạn Cần Chọn Giới Tính Trước Khi Lưu");
return;
}
if (cbChucVu.Text == "" || cbChucVu.Text == null)
{
MessageBox.Show("Bạn cần Chọn Chức Vụ Trước Khi Lưu");
return;
}
if (cbKhoHang.Text == "" || cbKhoHang.Text == null)
{
MessageBox.Show("Bạn cần Chọn Kho Hàng Trước Khi Lưu ");
return;
}
NhanVien nhanVien = new NhanVien()
{
MaNhanVien = texMaNhanVien.Text,
TenNhanVien = texTenNhanVien.Text,
ChungMinhThu = texCMT.Text,
NgaySinh = dateNgaySinh.Value,
GioiTinh = cbGioiTinh.Text,
DiaChi = texDiaChi.Text,
SoDienThoai = texDienThoai.Text,
Email = texEmail.Text,
ChucVu = cbChucVu.Text,
TienLuong = texTienLuong.Text,
NgayVaoLam = dateNgayVaoLam.Value
};
if (cbKhoHang.SelectedIndex != -1)
{
KhoHang khoHang = cbKhoHang.SelectedItem as KhoHang;
nhanVien.KhoHang = khoHang.MaKhoHang;
}
HienThiNhanVienBLL hienThiNhanVienBLL = new HienThiNhanVienBLL();
hienThiNhanVienBLL.SuaThongTinNhanVien(nhanVien);
if (KKhoHang != null)
{
HienThiDanhSachNhanVienTheoKhoHang(KKhoHang);
}
else
{
HienThiDanhSachNhanVien();
}
}
private void cmBoxKhoHang_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
string id = cmBoxKhoHang.SelectedValue.ToString();
KhoHang kh = CuaHangBUS.GetMaKieuByMaCH(id, txtboxMaKieuSP.Text);
txtSoLuongTonKho.Text = kh.SoLuong.ToString();
txtboxMaKieuSP.Text = kh.MaKieu.ToString();
}
catch { }
}
public ActionResult DatHang(FormCollection f)
{
if(Session["TaiKhoan"] == null || Session["TaiKhoan"].ToString() == "")
{
return RedirectToAction("Dangky","Customer");
}
if(Session["ShoppingCart"] == null)
{
return RedirectToAction("Index","Home");
}
ViewBag.listSC = GetShoppingCart();
DonDatHang ddh = new DonDatHang();
Customer kh = (Customer)Session["TaiKhoan"];
List<ShoppingCart> listSC = GetShoppingCart();
ddh.tinhtrang = 1;
ddh.idkhachhang = kh.id;
ddh.ngaydathang = DateTime.Now;
ddh.tongtien = (int)TongTien();
int check = db.insertDonDatHang(ddh);
int id = db.getDonDatHang(ddh.idkhachhang, ddh.ngaydathang);
if(check == 1)
{
foreach (var item in listSC)
{
CTDonDatHang ct = new CTDonDatHang();
ct.iddonhang = id;
ct.idsanpham = item.MaSP;
ct.soluong = item.SoLuong;
ct.size = item.Size;
int check1 = db.insertCTDonDatHang(ct);
if( check1 == 1)
{
KhoHang kho = new KhoHang();
kho.soluong = item.SoLuong;
kho.idsanpham = item.MaSP;
kho.size = item.Size;
db.UpdateKhoHang(kho);
}
}
}
kh.tenkh = f.Get("txtHoTen").ToString();
kh.diachikh = f.Get("txtDiaChi").ToString();
kh.email = f.Get("txtEmail").ToString();
kh.dienthoai = f.Get("txtSdt").ToString();
int updateCustomer = db.updateCustomer(kh);
if (updateCustomer != 1)
{
return RedirectToAction("ThongTinDonHang", "ShoppingCart");
}
Session["ShoppingCart"] = null;
return RedirectToAction("Index","Home");
}
protected override void Render(HtmlTextWriter writer)
{
var sb = new StringBuilder();
var cs = this.Page.ClientScript;
var c = HttpContext.Current;
#region Variables
var ID = c.Request["ID"];
var Ten = c.Request["Ten"];
var DiaChi = c.Request["DiaChi"];
var Ma = c.Request["Ma"];
var KV_ID = c.Request["KV_ID"];
var HH_ID = c.Request["HH_ID"];
if(!Security.IsAuthenticated())
{
Response.Clear();
Response.End();
}
var _q = c.Request["q"];
#endregion
var listRow = new List<jgridRow>();
switch (subAct)
{
case "get":
#region get
var pagerGet = KhoHangDal.pagerNormal("", false, "KH_" + jgrsidx + " " + jgrsord, _q, Convert.ToInt32(jgRows));
foreach (var item in pagerGet.List)
{
listRow.Add(new jgridRow(item.ID.ToString(), new string[] {
item.ID.ToString()
, item.Ma
, item.Ten
, item.DiaChi
, item.KV_Ten
}));
}
jgrid gridSPAdm = new jgrid(string.IsNullOrEmpty(jgrpage) ? "1" : jgrpage
, pagerGet.TotalPages.ToString()
, pagerGet.Total.ToString()
, listRow);
sb.Append(JavaScriptConvert.SerializeObject(gridSPAdm));
break;
#endregion
case "search":
#region search
var pagerGetSearch = KhoHangDal.pagerNormal("", false, "KH_Ten", _q, 20);
sb.Append(JavaScriptConvert.SerializeObject(pagerGetSearch.List));
break;
#endregion
case "searchByHangHoa":
#region search
var pagerGetSearchByHangHoa = KhoHangDal.SelectByHangHoa(HH_ID);
sb.Append(JavaScriptConvert.SerializeObject(pagerGetSearchByHangHoa));
break;
#endregion
case "save":
#region chỉnh sửa
if (Security.IsAuthenticated())
{
var item = new KhoHang();
if (!string.IsNullOrEmpty(ID))
{
item = KhoHangDal.SelectById(new Guid(ID));
}
item.Ma = Ma;
item.DiaChi = DiaChi;
item.Ten = Ten;
if(!string.IsNullOrEmpty(KV_ID))
{
item.KV_ID = new Guid(KV_ID);
}
if (!string.IsNullOrEmpty(ID))
{
item = KhoHangDal.Update(item);
}
else
{
item.ID = Guid.NewGuid();
item = KhoHangDal.Insert(item);
}
sb.Append("1");
}
break;
#endregion
case "edit":
#region chỉnh sửa
if (!string.IsNullOrEmpty(ID))
{
sb.AppendFormat("({0})", JavaScriptConvert.SerializeObject(KhoHangDal.SelectById(new Guid(ID))));
}
break;
#endregion
case "del":
#region chỉnh sửa
if (!string.IsNullOrEmpty(ID))
{
KhoHangDal.DeleteById(new Guid(ID));
}
break;
#endregion
case "scpt":
#region Nạp js
sb.AppendFormat(@"{0}"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.pmSpa.khoHangMgr.JScript1.js"));
break;
#endregion
default:
#region default
{
var ListFn = FunctionDal.SelectByUserAndFNID(Security.Username, fnId);
sb.Append(Lib.GetResource(Assembly.GetExecutingAssembly(), "mdl.htm"));
sb.AppendFormat(@"<script>$.getScript('{0}',function(){1});</script>"
, cs.GetWebResourceUrl(typeof(Class1), "appStore.pmSpa.khoHangMgr.JScript1.js")
, "{KhoHangMgrFn.loadgrid();}");
sb.AppendFormat("<script>adm.validFn('{0}');</script>", JavaScriptConvert.SerializeObject(ListFn));
break;
}
#endregion
}
writer.Write(sb.ToString());
base.Render(writer);
}
