public bool Insert(CBillBLL p) { bool isSuccess = false; SqlConnection cn = new SqlConnection(cnString); cn = CDatabase.Get_Database_Connection(); try { string sqlText = "insert into HOA_DON(MAHD,MANV,MADL,NGAYLAP,MAKM,TONGTIEN) values (@m_MaHD,@m_MaNV,@m_MaDL,@m_NgayLap, @m_MaKM, @m_TongTien)"; SqlCommand cmd = new SqlCommand(sqlText, cn); cmd.Parameters.AddWithValue("@m_MaHD", p.m_MaHD); cmd.Parameters.AddWithValue("@m_MaNV", p.m_MaNV); cmd.Parameters.AddWithValue("@m_MaDL", p.m_MaDL); cmd.Parameters.AddWithValue("@m_NgayLap", p.m_NgayLap); cmd.Parameters.AddWithValue("@m_MaKM", p.m_MaKM); cmd.Parameters.AddWithValue("@m_TongTien", p.m_TongTien); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CDatabase.Close_Database_Connection(); } return(isSuccess); }
//public bool Update(CProductBLL p) //{ // bool isSuccess = false; // SqlConnection cn = new SqlConnection(cnString); // cn = CDatabase.Get_Database_Connection(); // try // { // string sqlText = "UPDATE HANG_HOA SET MAHH=@m_MaHH,MAHTDG=@m_MaHTDG,MANHOM=@m_MaNhom,TENHH=@m_TenHH, DVT=@m_DVT, DONGIA=@m_DonGia, SLTON=@m_SLTon WHERE MAHH=@m_MaHH"; // SqlCommand cmd = new SqlCommand(sqlText, cn); // cmd.Parameters.AddWithValue("@m_MaHH", p.m_MaHH); // cmd.Parameters.AddWithValue("@m_MaHTDG", p.m_MaHTDG); // cmd.Parameters.AddWithValue("@m_MaNhom", p.m_MaNhom); // cmd.Parameters.AddWithValue("@m_TenHH", p.m_TenHH); // cmd.Parameters.AddWithValue("@m_DVT", p.m_DVT); // cmd.Parameters.AddWithValue("@m_DonGia", p.m_DonGia); // cmd.Parameters.AddWithValue("@m_SLTon", p.m_SLTon); // int rows = cmd.ExecuteNonQuery(); // if (rows > 0) // { // isSuccess = true; // } // else // { // isSuccess = false; // } // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } // finally // { // CDatabase.Close_Database_Connection(); // } // return isSuccess; //} public bool Delete(CBillBLL p) { bool isSuccess = false; SqlConnection cn = new SqlConnection(cnString); cn = CDatabase.Get_Database_Connection(); try { string sqlText = "DELETE FROM HOA_DON WHERE MAHD=@m_MaHD"; SqlCommand cmd = new SqlCommand(sqlText, cn); cmd.Parameters.AddWithValue("@m_MaHD", p.m_MaHD); int rows = cmd.ExecuteNonQuery(); if (rows > 0) { isSuccess = true; } else { isSuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { CDatabase.Close_Database_Connection(); } return(isSuccess); }