public int AddProduct(DtoProduct data) { SqlParameter[] para = { new SqlParameter("@MaSanPham", data.MaSanPham), new SqlParameter("@TenSanPham", data.TenSanPham), new SqlParameter("@LoaiSanPham", data.LoaiSanPham), new SqlParameter("@ThoiGianBaoHanh", data.ThoiGianBaoHanh), new SqlParameter("@DonGiaNhap", data.DonGiaNhap), new SqlParameter("@DonGiaBan", data.DonGiaBan), new SqlParameter("@SoLuong", data.SoLuong), new SqlParameter("@DonViTinh", data.DonViTinh), new SqlParameter("@GhiChu", data.GhiChu) }; try { return SqlHelper.ExecuteNonQuery(Constants.ConnectionString, CommandType.StoredProcedure, "AddProduct", para); } catch (SqlException sqlEx) { throw new ArgumentException(Constants.MsgExceptionSql); } catch (Exception ex) { throw ex; } }
public DtoProduct GetProductByID(string id) { try { DataTable dt = SqlHelper.ExecuteDataset(Constants.ConnectionString, CommandType.Text, "select * from SANPHAM where MaSanPham = @MaSanPham", new SqlParameter("@MaSanPham", id)).Tables[0]; DtoProduct dto = new DtoProduct( dt.Rows[0].ItemArray[0].ToString(), dt.Rows[0].ItemArray[1].ToString(), dt.Rows[0].ItemArray[2].ToString(), int.Parse(dt.Rows[0].ItemArray[3].ToString()), double.Parse(dt.Rows[0].ItemArray[4].ToString()), double.Parse(dt.Rows[0].ItemArray[5].ToString()), int.Parse(dt.Rows[0].ItemArray[6].ToString()), dt.Rows[0].ItemArray[7].ToString(), dt.Rows[0].ItemArray[8].ToString() ); return dto; } catch (SqlException sqlEx) { throw new Exception("Lỗi kết nối cơ sở dữ liệu!"); } catch (Exception ex) { throw ex; } }
public int AddProduct(DtoProduct data) { SqlParameter[] para = { new SqlParameter("@MaSanPham", data.MaSanPham), new SqlParameter("@TenSanPham", data.TenSanPham), new SqlParameter("@LoaiSanPham", data.LoaiSanPham), new SqlParameter("@ThoiGianBaoHanh", data.ThoiGianBaoHanh), new SqlParameter("@DonGiaNhap", data.DonGiaNhap), new SqlParameter("@DonGiaBan", data.DonGiaBan), new SqlParameter("@SoLuong", data.SoLuong), new SqlParameter("@DonViTinh", data.DonViTinh), new SqlParameter("@GhiChu", data.GhiChu) }; try { return SqlHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, "AddProduct", para); } catch (SqlException e) { return 0; throw e; } catch (Exception e) { return 0; throw e; } }
public bool EditProduct(DtoProduct data) { try { return _dalProduct.EditProduct(data) == 1 ? true : false; } catch (Exception) { return false; } }
public override bool Equals(object obj) { DtoProduct _obj = (DtoProduct)obj; if (_obj.MaSanPham == MaSanPham && _obj.LoaiSanPham == LoaiSanPham && _obj.GhiChu == GhiChu && _obj.DonViTinh == DonViTinh && _obj.DonGiaNhap == DonGiaNhap && _obj.DonGiaBan == DonGiaBan && _obj.SoLuong == SoLuong && _obj.TenSanPham == TenSanPham && _obj.ThoiGianBaoHanh == ThoiGianBaoHanh) { return(true); } return(false); }
private void btnLuu_Click(object sender, EventArgs e) { if (!CheckTextBox()) { return; } DtoProduct data = new DtoProduct( txtMaSanPham.Text, txtTenSanPham.Text, txtLoaiSanPham.Text, int.Parse(txtThoiGianBaoHanh.Text), double.Parse(txtDonGiaNhap.Text), double.Parse(txtDonGiaBan.Text), int.Parse(txtSoLuong.Text), txtDonViTinh.Text, txtGhiChu.Text); if (_bllProduct.AddProduct(data)) { MessageBox.Show(Constants.MsgNotificationSuccessfuly); btnLuu.Enabled = false; } else { MessageBox.Show(Constants.MsgAlreadyExist); } txtMaSanPham.Enabled = false; btnLamTuoi.PerformClick(); }
public DtoProduct GetProductByID(string id) { DataTable dt = SqlHelper.ExecuteDataset(con, CommandType.Text, "select * from SANPHAM where MaSanPham = @MaSanPham", new SqlParameter("@MaSanPham", id)).Tables[0]; DtoProduct dto = new DtoProduct(); if (dt.Rows.Count > 0) { dto = new DtoProduct( dt.Rows[0].ItemArray[0].ToString(), dt.Rows[0].ItemArray[1].ToString(), dt.Rows[0].ItemArray[2].ToString(), int.Parse(dt.Rows[0].ItemArray[3].ToString()), double.Parse(dt.Rows[0].ItemArray[4].ToString()), double.Parse(dt.Rows[0].ItemArray[5].ToString()), int.Parse(dt.Rows[0].ItemArray[6].ToString()), dt.Rows[0].ItemArray[7].ToString(), dt.Rows[0].ItemArray[8].ToString() ); } return dto; }
private void btnLuu_Click(object sender, EventArgs e) { try { string keyselect = ""; if (!CheckTextBox()) { return; } DtoProduct data = new DtoProduct( txtMaSanPham.Text, txtTenSanPham.Text, txtLoaiSanPham.Text, int.Parse(txtThoiGianBaoHanh.Text), double.Parse(txtDonGiaNhap.Text), double.Parse(txtDonGiaBan.Text), 0, txtDonViTinh.Text, txtGhiChu.Text); keyselect = data.MaSanPham; if (_bllProduct.AddProduct(data)) { //MessageBox.Show(Constants.MsgNotificationSuccessfuly); DisplayNotify(Constants.MsgNotificationSuccessfuly, 1); btnLuu.Enabled = false; txtMaSanPham.Enabled = false; // btnLamTuoi.PerformClick(); dgvListProduct.DataSource = _bllProduct.GetListProducts(); DgvDataBindings(); SelectRow(dgvListProduct, keyselect); } else { DisplayNotify(Constants.MsgAlreadyExist, -1); //MessageBox.Show(Constants.MsgAlreadyExist); } txtMaSanPham.Enabled = false; } catch (Exception ex) { DisplayNotify(ex.Message, -1); } }