public HttpResponseMessage GetAll() { try { HttpResponseMessage reponse = null; var entity = db.NhaCungCaps.ToList(); List <NCCDTO> ListNCC = new List <NCCDTO>(); if (entity.Count <= 0) { reponse = Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không Có Dữ Liệu"); } else { foreach (var item in entity) { NCCDTO ncc = new NCCDTO(); ncc.MaNCC = item.MaNCC; ncc.TenNCC = item.TenNCC; ncc.ThongTin = item.ThongTin; ncc.BiDanh = item.BiDanh; ncc.NgayTao = item.NgayTao; ncc.NgayCapNhat = item.NgayCapNhat; ListNCC.Add(ncc); } reponse = Request.CreateResponse(HttpStatusCode.OK, ListNCC); } return(reponse); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage EditNCC([FromBody] NCCDTO ncc) { try { var entity = db.NhaCungCaps.SingleOrDefault(x => x.MaNCC == ncc.MaNCC); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không Tìm Thấy Nhà Cung Cấp")); } else { entity.TenNCC = ncc.TenNCC; entity.ThongTin = ncc.ThongTin; entity.BiDanh = ncc.BiDanh; entity.LoGo = ncc.LoGo; entity.NgayTao = ncc.NgayTao; entity.NgayCapNhat = DateTime.Now; db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, entity)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage GetMegaMenu() { try { List <LoaiSP> entity = db.LoaiSPs.ToList(); List <LoaiSPDTO> listloaisp = new List <LoaiSPDTO>(); foreach (var item in entity) { LoaiSPDTO loaisp = new LoaiSPDTO(); loaisp.MaLoaiSP = item.MaLoaiSP; loaisp.TenLoaiSP = item.TenLoaiSP; loaisp.MaLoaiSP = item.MaLoaiSP; List <NCCDTO> listncc = new List <NCCDTO>(); foreach (var item2 in item.SanPhams.GroupBy(x => x.NhaCungCap)) { NCCDTO ncc = new NCCDTO(); ncc.TenNCC = item2.Key.TenNCC; ncc.MaNCC = item2.Key.MaNCC; listncc.Add(ncc); loaisp.ListNCC = listncc; } listloaisp.Add(loaisp); } return(Request.CreateResponse(HttpStatusCode.OK, listloaisp)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage GetAll(int page, int pagesize, string keyword) { try { int totalrows = 0; var entity = db.LoaiSPs.ToList(); if (!string.IsNullOrEmpty(keyword)) { entity = db.LoaiSPs.Where(x => x.TenLoaiSP.Contains(keyword)).ToList(); } if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found")); } else { var query = entity.OrderByDescending(x => x.NgayCapNhat).Skip(page * pagesize).Take(pagesize).ToList(); totalrows = entity.Count(); List <LoaiSPDTO> ListloaiSP = new List <LoaiSPDTO>(); foreach (var item in query) { LoaiSPDTO loaisp = new LoaiSPDTO(); loaisp.MaLoaiSP = item.MaLoaiSP; loaisp.TenLoaiSP = item.TenLoaiSP; loaisp.BiDanh = item.BiDanh; loaisp.NgayCapNhat = item.NgayCapNhat; loaisp.NgayTao = item.NgayTao; loaisp.Total = item.SanPhams.Count(); List <NCCDTO> findncc = new List <NCCDTO>(); foreach (var item2 in item.SanPhams.GroupBy(x => x.NhaCungCap)) { NCCDTO ncc = new NCCDTO(); ncc.MaNCC = item2.Key.MaNCC; ncc.TenNCC = item2.Key.TenNCC; ncc.SLSP = item.SanPhams.Where(x => x.MaNCC == item2.Key.MaNCC).Count(); findncc.Add(ncc); loaisp.ListNCC = findncc; } ListloaiSP.Add(loaisp); } var pagin = new Pager <LoaiSPDTO>() { Item = ListloaiSP, Page = page, TotalCount = totalrows, TotalPage = (int)Math.Ceiling((decimal)totalrows / pagesize), }; return(Request.CreateResponse(HttpStatusCode.OK, pagin)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
private void btnThem_Click(object sender, EventArgs e) { NCCDTO NCCDTO = new NCCDTO() { ConQuanLy = true }; ThemNCC frm = new ThemNCC(true, NCCDTO); frm.ShowDialog(); hienThi(); }
public static void saveNCC(NCCDTO hs, string method) { SqlParameter[] sqlP = new SqlParameter[4]; sqlP[0] = new SqlParameter("@MaNCC", hs.MaNCC1); sqlP[1] = new SqlParameter("@TenNCC", hs.TenNCC1); sqlP[2] = new SqlParameter("@DiaChi", hs.DiaChi1); sqlP[3] = new SqlParameter("@DienThoai", hs.DienThoai1); if (method == sys.INSERT) { GenericDAL.execNonQuery("sp_InsertNCC", sqlP, Conn); } else if (method == sys.UPDATE) { GenericDAL.execNonQuery("sp_UpdateNCC", sqlP, Conn); } }
public ThemNCC(bool _isAddNew1, NCCDTO NCCDTO) { InitializeComponent(); _isAddNew = _isAddNew1; txtMa.Text = NCCDTO.MaNCC; txtTen.Text = NCCDTO.TenNCC; gluKhuVuc.EditValue = NCCDTO.Tenkvncc; txtDiaChi.Text = NCCDTO.diachiNCC; txtDT.Text = NCCDTO.DTNCC; txtEmail.Text = NCCDTO.EmailNCC; ckbConQuanLy.Checked = NCCDTO.ConQuanLy; if (!_isAddNew) { txtMa.Enabled = false; } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["productid"] != null) { string id = Request.QueryString["productid"].ToString(); _product = _QLSP.getProductById(id); _NCC = _QLNCC.GeNCCbyiD(_product.Ncc); string idNCC = Request.QueryString["nccId"].ToString(); RptProuct_NCC.DataSource = _QLSP.GetProductByNCC(idNCC); RptProuct_NCC.DataBind(); } else { Response.Redirect("products.aspx"); } }
public HttpResponseMessage GetAll(int page, int pagesize, string keyword) { try { HttpResponseMessage reponse = null; var entity = db.NhaCungCaps.ToList(); if (!string.IsNullOrEmpty(keyword)) { entity = db.NhaCungCaps.Where(x => x.TenNCC.Contains(keyword)).ToList(); } var query = entity.OrderByDescending(x => x.NgayCapNhat).Skip(page * pagesize).Take(pagesize); var totalrows = entity.Count(); List <NCCDTO> ListNCC = new List <NCCDTO>(); if (entity.Count <= 0) { reponse = Request.CreateErrorResponse(HttpStatusCode.NotFound, "Không Có Dữ Liệu"); } else { foreach (var item in query) { NCCDTO ncc = new NCCDTO(); ncc.MaNCC = item.MaNCC; ncc.TenNCC = item.TenNCC; ncc.ThongTin = item.ThongTin; ncc.BiDanh = item.BiDanh; ncc.NgayTao = item.NgayTao; ncc.NgayCapNhat = item.NgayCapNhat; ListNCC.Add(ncc); } var pagin = new Pager <NCCDTO>() { Item = ListNCC, Page = page, TotalCount = totalrows, TotalPage = (int)Math.Ceiling((decimal)totalrows / pagesize), }; reponse = Request.CreateResponse(HttpStatusCode.OK, pagin); } return(reponse); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
/* in form*/ private NCCDTO checkData() { string ma = txtMaNCC.Text; string ten = txtTenNCC.Text; string diaChi = txtDiaChi.Text; string SDT = mtbDienThoai.Text; string z = string.Join("", txtMaNCC.Text.Where(char.IsDigit)); if (txtMaNCC.Text.Trim().Length == 0) { MessageBox.Show("Bạn Chưa Nhập Mã KH", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtMaNCC.Focus(); return(null); } else if (txtTenNCC.Text.Trim().Length == 0) { MessageBox.Show("Bạn Chưa Nhập Tên KH", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtTenNCC.Focus(); return(null); } else if (mtbDienThoai.Text.Trim().Length == 0) { MessageBox.Show("Bạn Chưa Nhập SĐT", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); mtbDienThoai.Focus(); return(null); } else if (txtDiaChi.Text.Trim().Length == 0) { MessageBox.Show("Bạn Chưa Nhập Địa Chỉ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtDiaChi.Focus(); return(null); } else if (txtMaNCC.Text.Contains("NCC") == false) { MessageBox.Show("Nhập Theo Định Dạng Là \"NCC\"", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtMaNCC.Focus(); return(null); } else if (z == "") { MessageBox.Show("Nhập Theo Định Dạng Là \"NCC\" và Thêm Số Đằng Sau", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtMaNCC.Focus(); return(null); } NCCDTO dto = new NCCDTO(ma, Handling.FormHandling.formatString(ten), diaChi, SDT); return(dto); }
public HttpResponseMessage GetById([FromUri] int id) { try { var entity = db.NhaCungCaps.Find(id); NCCDTO ncc = new NCCDTO(); ncc.MaNCC = entity.MaNCC; ncc.TenNCC = entity.TenNCC; ncc.ThongTin = entity.ThongTin; ncc.BiDanh = entity.BiDanh; ncc.LoGo = entity.LoGo; ncc.NgayTao = entity.NgayTao; return(Request.CreateResponse(HttpStatusCode.OK, ncc)); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { return; } if (Session["Loai"] != null) { int Loai = int.Parse(Session["Loai"].ToString()); if (Loai == 1) { if (Session["MaNCC"] != null) { string Ma = Session["MaNCC"].ToString(); _ncc = _QLNCC.GeNCCbyiD(Ma); txtProducerName.Text = _ncc.TenNCC; txtAddress.Text = _ncc.Diachi; txtActiveTime.Text = _ncc.Giohoatdong; if (_ncc.Dvship == true) { cbShip.Checked = true; } else { cbShip.Checked = false; } txtMail.Text = _ncc.Mail; URL.ImageUrl = _ncc.Url; URL.Visible = true; } } else { Response.Redirect("login.aspx"); } } else { Response.Redirect("login.aspx"); } }
private void buttonThem_Click(object sender, EventArgs e) { if (textBoxMaNCC.TextLength == 0) { MaterialMessageBox.Show("Vui lòng nhập mã NCC", "Hướng dẫn"); return; } NCCDTO nCC = new NCCDTO(textBoxMaNCC.Text, textBoxTenNCC.Text, multiLineTextBoxDiaChiNCC.Text, textBoxSDTNCC.Text); int result = NCCBUS.Instance.ThemNCC(nCC); if (result != 1) { MaterialMessageBox.Show("Chưa thêm được NCC " + nCC.MaNCC, "Thất bại"); return; } LoadDSNCC(); }
public HttpResponseMessage GetAll() { try { var entity = db.LoaiSPs.ToList(); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Found")); } else { List <LoaiSPDTO> ListloaiSP = new List <LoaiSPDTO>(); foreach (var item in entity) { LoaiSPDTO loaisp = new LoaiSPDTO(); loaisp.MaLoaiSP = item.MaLoaiSP; loaisp.TenLoaiSP = item.TenLoaiSP; loaisp.BiDanh = item.BiDanh; loaisp.NgayCapNhat = item.NgayCapNhat; loaisp.NgayTao = item.NgayTao; loaisp.Total = item.SanPhams.Count(); List <NCCDTO> findncc = new List <NCCDTO>(); foreach (var item2 in item.SanPhams.GroupBy(x => x.NhaCungCap)) { NCCDTO ncc = new NCCDTO(); ncc.MaNCC = item2.Key.MaNCC; ncc.TenNCC = item2.Key.TenNCC; ncc.SLSP = item.SanPhams.Where(x => x.MaNCC == item2.Key.MaNCC).Count(); findncc.Add(ncc); loaisp.ListNCC = findncc; } ListloaiSP.Add(loaisp); } return(Request.CreateResponse(HttpStatusCode.OK, ListloaiSP)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
private void btnSua_Click(object sender, EventArgs e) { if (checkDuplicated() == 2) { MessageBox.Show("Không Có Mã Đó Để Thay Đổi Liên Quan", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtMaNCC.Text = ""; return; } else { NCCDTO ob = checkData(); if (ob != null) { B_NCC.saveNCC(ob, sys.UPDATE); MessageBox.Show("Sửa Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); dt = B_NCC.GetAllNCC(); dgvNCC.DataSource = dt; clearTxt(); } } }
public HttpResponseMessage TaoMoi([FromBody] NCCDTO ncc) { try { HttpResponseMessage reponse = null; var entity = new NhaCungCap(); entity.TenNCC = ncc.TenNCC; entity.ThongTin = ncc.ThongTin; entity.BiDanh = ncc.BiDanh; entity.LoGo = ncc.LoGo; entity.NgayTao = DateTime.Now; db.NhaCungCaps.Add(entity); db.SaveChanges(); reponse = Request.CreateResponse(HttpStatusCode.OK, entity); return(reponse); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
private void btnThem_Click(object sender, EventArgs e) { NCCDTO ob = checkData(); if (ob != null) { if (checkDuplicated() == 1) { MessageBox.Show("Mã Nhà Cung Cấp Trùng", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); txtMaNCC.Focus(); return; } else { B_NCC.saveNCC(ob, sys.INSERT); MessageBox.Show("Thêm Thành Công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); dt = B_NCC.GetAllNCC(); dgvNCC.DataSource = dt; clearTxt(); } } }
private void btnSua_Click(object sender, EventArgs e) { _currentRowIndex = gridView1.FocusedRowHandle; if (_currentRowIndex < 0) { return; } NCCDTO NCCDTO = new NCCDTO() { MaNCC = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["MaNCC"]).ToString(), TenNCC = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["TenNCC"]).ToString(), Tenkvncc = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["TenKV"]).ToString(), diachiNCC = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["diachiNCC"]).ToString(), DTNCC = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["DTNCC"]).ToString(), EmailNCC = gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["EmailNCC"]).ToString(), ConQuanLy = bool.Parse(gridView1.GetRowCellValue(_currentRowIndex, gridView1.Columns["ConQuanLy"]).ToString()), }; ThemNCC frm = new ThemNCC(false, NCCDTO); frm.ShowDialog(); hienThi(); }
public static void saveNCC(NCCDTO hs, string method) { D_NCC.saveNCC(hs, method); }