public BanHang.Domain.BanHang Execute()
{
BanHang.Domain.BanHang data = null;
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT SUM(SoLuong),SUM(Giaban) FROM BanHang WHERE CONVERT(date,NgayBan) = @NgayBan";
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "@NgayBan",
Value = item.NgayBan,
SqlDbType = System.Data.SqlDbType.DateTime
});
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
data.SoLuong = Convert.ToInt32(reader["SoLuong"]);
data.Giaban = Convert.ToInt32(reader["Giaban"]);
}
reader.Close();
}
conn.Close();
}
}
return(data);
}
public BanHang.Domain.BanHang Execute()
{
var data = new BanHang.Domain.BanHang();
using (var conn = new SqlConnection(ConnectionString))
{
using (var cmd = conn.CreateCommand())
{
conn.Open();
cmd.CommandText = "SELECT * FROM BanHang";
conn.Close();
}
}
return(data);
}
private void bunifuTileButton2_Click(object sender, EventArgs e)
{
try
{
if (rand == 0)
{
rand = getRand(2);
}
var data = new BanHang.Domain.BanHang();
data.HanghoaId = this.cbbHangHoa.SelectedValue.ToString();
data.NhomHanghoaId = this.cbbNhomHangHoa.SelectedValue.ToString();
data.TenSanPham = this.cbbHangHoa.Text;
data.NgayBan = DateTime.Now.ToString();
data.SoLuong = Convert.ToInt32(this.txtSoLuong.Text);
data.Giaban = Convert.ToInt32(this.txtSoLuong.Text) * Convert.ToInt32(this.txtGiaBan.Text);
data.ID = rand;
using (var cmd = new BanHangAddRepository())
{
cmd.item = data;
cmd.Execute();
}
using (var cmd = new BanHangSubBusiness())
{
cmd.HanghoaId = data.HanghoaId;
cmd.SoLuong = data.SoLuong;
cmd.Execute();
}
using (var cmd = new BanHangViewBusiness())
{
cmd.ID = data.ID;
this.banHangBindingSource.DataSource = cmd.Execute();
}
this.txtSoLuong.Text = "";
}
catch
{
MessageBox.Show("Vui lòng kiểm tra lại!", "CÓ LỖI XẢY RA!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
