public static bool payAndInsertDetailBill(DataGridView dgv, bill bil)
{
MessageBox.Show("Toan 3");
bool check = false;;
int i = 0;
for (i = 0; i < dgv.Rows.Count; i++)
{
check = false;
detailBill detaiBill = new detailBill();
detaiBill.IdBill = bil.IdBill;
detaiBill.IdProduct = int.Parse(dgv.Rows[i].Cells["idsp"].Value.ToString());
detaiBill.Price = int.Parse(dgv.Rows[i].Cells["giaban"].Value.ToString());
detaiBill.Quantity = int.Parse(dgv.Rows[i].Cells["soluong"].Value.ToString());
string sql = "insert into CHITIETHOADON values('" + detaiBill.IdBill + "','" + detaiBill.IdProduct + "','" + detaiBill.Price + "','" + detaiBill.Quantity + "')";
if (ConnectDAO.queryNonQuery(sql))
{
check = true;
}
if (!check)
{
break;
}
//Console.WriteLine("chi tuet HOA DON");
//Console.WriteLine(" ma ct HOA DON" + detaiBill.IdBill);
//Console.WriteLine(" id san pham" + detaiBill.IdProduct);
//Console.WriteLine("gia" + detaiBill.Price);
//Console.WriteLine("sol luong" + detaiBill.Quantity);
}
return(check);
}
public static DataTable filterCombox(int idLoai)
{
DataTable data = null;
string sql = "select SANPHAM.idSp ,SANPHAM.tenSp,LOAISANPHAM.tenLoai,SANPHAM.size,SANPHAM.mausac,giaban,SANPHAM.doituongsudung,SANPHAM.note from SANPHAM, LOAISANPHAM ,HoaDonNhapHang,nhacungcap where SANPHAM.idLOAISANPHAM = LOAISANPHAM.idLoai and sanpham.idSP=hoadonnhaphang.IdSanPham and NHACUNGCAP.IdNCC= sanpham.IdNhaCungCap and idloaisanpham='" + idLoai + "'; ";
data = ConnectDAO.getDataTable(sql);
return(data);
}
public static DataTable getListProduct()
{
List <product> list = new List <product>();
string sql = "select SANPHAM.idSp ,SANPHAM.tenSp,LOAISANPHAM.tenLoai,SANPHAM.size,SANPHAM.mausac,giaban,SANPHAM.doituongsudung,SANPHAM.note from SANPHAM, LOAISANPHAM ,HoaDonNhapHang,nhacungcap where SANPHAM.idLOAISANPHAM = LOAISANPHAM.idLoai and sanpham.idSP=hoadonnhaphang.IdSanPham and NHACUNGCAP.IdNCC= sanpham.IdNhaCungCap; ";
DataTable dtableProduct = ConnectDAO.getDataTable(sql);
return(dtableProduct);
}
public static DataTable takeListColor()
{
String sql = "select (mausac) from SANPHAM group by mausac order by mausac;";
DataTable dtable = ConnectDAO.getDataTable(sql);
if (dtable.Rows.Count == 0)
{
return(null);
}
return(dtable);
}
public static DataTable takeListSize()
{
String sql = "select (size) from SANPHAM group by size order by size;";
DataTable dtableSize = ConnectDAO.getDataTable(sql);
if (dtableSize.Rows.Count == 0)
{
return(null);
}
return(dtableSize);
}
public static bool checkExistAccount(String name, String pass)
{
String sql = "select * from acount where userName='******' and pass='******'";
DataTable da = ConnectDAO.getDataTable(sql);
if (da.Rows.Count > 0)
{
return(true);
}
return(false);
}
public static DataTable takeListType()
{
String sql = "select * from loaisanpham ";
DataTable dtableType = ConnectDAO.getDataTable(sql);
if (dtableType.Rows.Count == 0)
{
MessageBox.Show("base base loaisanpham null ");
return(null);
}
return(dtableType);
}
public static bool insertCustomerDAO(customer cus)
{
Console.WriteLine(cus.Name);
Console.WriteLine(cus.Address);
Console.WriteLine(cus.Phone);
Console.WriteLine(cus.Gender);
string sql = "insert into khachhang values('',N'" + cus.Name + "',N'" + cus.Address + "',N'" + cus.Phone + "',N'" + cus.Gender + "')";
if (ConnectDAO.queryNonQuery(sql))
{
return(true);
}
return(false);
}
public static bool payAndInsertBill(bill bil)
{
string sql = "insert into HOADON values('" + bil.IdBill + "',N'" + bil.IdStaff + "','" + CONST.customer.Id + "','" + bil.DayOfSell.ToString("yyyy/MM/dd") + "','" + bil.TotalMoney + "')";
if (ConnectDAO.queryNonQuery(sql))
{
return(true);
}
//Console.WriteLine("HOA DON");
//Console.WriteLine(" ma HOA DON" + bil.IdBill);
//Console.WriteLine("id nhan vien" + bil.IdStaff);
//Console.WriteLine("id n kHach" + CONST.customer.Id);
//Console.WriteLine("Ngay ban" + bil.DayOfSell);
//Console.WriteLine("tong tien" + bil.TotalMoney);
return(false);
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
ConnectDAO c = new ConnectDAO();
}
