public void ThemHoatDong(ThongKeDTO tkDTO)
{
String SQL = @"INSERT INTO ThongKe VALUES ('{0}', {1})";
String query = string.Format(SQL, tkDTO.TenHoatDong, tkDTO.ChiPhi);
DataProvider.ExecuteQuery(query);
}
public void SuaThongTin(ThongKeDTO tk)
{
String updateSQL = @"UPDATE ThongKe SET TenHoatDong = N'{0}', ChiPhi = {1}";
String query = string.Format(updateSQL, tk.TenHoatDong, tk.ChiPhi);
DataProvider.ExecuteQuery(query);
}
public int ThemTua(ThongKeDTO obj)
{
int result = 0;
string query = " INSERT INTO " + obj.TenBang + " VALUES ('" + obj.Ngay + "','" + obj.MaNV + "','" + obj.MaDV + "', " + obj.ThoiGianDV + "," + obj.TienCer + "," + obj.TienMat + ")";
DataConfig config = new DataConfig();
result = config.fExecuteNoneQuery(query);
return(result);
}
private void btnDelete_Click(object sender, EventArgs e)
{
ThongKeDTO obj = new ThongKeDTO();
//obj.STT = rowEnterIndex;
QLThemDichVuBUS _Service = new QLThemDichVuBUS();
_Service.XoaTua(TenBang, rowEnterIndex.ToString());
//LoadDataDay();
DataKhiChonNhanVien();
LoadDataTab2();
}
public List <ThongKeDTO> ThongKeDT(string str)
{
List <ThongKeDTO> ThongKeList = new List <ThongKeDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("EXEC THONGKE @TUNGAY , @DENNGAY ", new object[] { str });
foreach (DataRow item in data.Rows)
{
ThongKeDTO ThongKe = new ThongKeDTO(item);
ThongKeList.Add(ThongKe);
}
return(ThongKeList);
}
public List <ThongKeDTO> GetTHONGKE(DateTime TUNGAY, DateTime DENNGAY)
{
List <ThongKeDTO> list = new List <ThongKeDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("dbo.THONGKE_GETALL @TUNGAY , @DENNGAY ", new object[] { TUNGAY, DENNGAY });
foreach (DataRow item in data.Rows)
{
ThongKeDTO thongke = new ThongKeDTO(item);
list.Add(thongke);
}
return(list);
}
public List <ThongKeDTO> GetListThongKe()
{
List <ThongKeDTO> list = new List <ThongKeDTO>();
DataTable data = DataProvider.Instance.ExecuteQuery("select IDGiay , TenGiay , SoLuong , DonGia , (SoLuong * DonGia) as N'TongTien' from GIAY");
foreach (DataRow item in data.Rows)
{
ThongKeDTO tk = new ThongKeDTO(item);
list.Add(tk);
}
return(list);
}
protected void btn_Them_Click(object sender, EventArgs e)
{
ThongKeDTO tkDTO = new ThongKeDTO();
tkDTO.TenHoatDong = tbTenHD.Text;
tkDTO.ChiPhi = (float)Convert.ToDouble(tbChiPhi.Text);
ThongKeBUS tkBUS = new ThongKeBUS();
tkBUS.ThemHoatDong(tkDTO);
FilGVDanhSachHoatDong();
}
public void insertThongke(int price)
{
int valueMonth;
int valYear;
string date = DateTime.Now.ToString();
valueMonth = 3;
valYear = 2;
ThongKeDTO TK = new ThongKeDTO(price, valYear, date, valueMonth, tenSPG);
_Thongke.ThemThongKe(TK);
}
public ThongKeDTO LayThongTin(string tendangnhap)
{
ThongKeDTO ThongKeDTO = null;
String query = string.Format("SELECT * FROM NguoiDung WHERE TenDangNhap = '{0}'", tendangnhap);
DataTable dt = DataProvider.ExecuteQuery(query);
if (dt.Rows.Count > 0)
{
ThongKeDTO thongKeDTO = new ThongKeDTO();
thongKeDTO.MaHoatDong = Convert.ToInt32(dt.Rows[0]["MaHoatDong"]);
thongKeDTO.TenHoatDong = dt.Rows[0]["TenHoatDong"].ToString();
thongKeDTO.ChiPhi = Convert.ToInt64(dt.Rows[0]["ChiPhi"]);
}
return(ThongKeDTO);
}
public List <ThongKeDTO> LayDanhSach()
{
List <ThongKeDTO> listThongKeDTO = new List <ThongKeDTO>();
String query = "SELECT * FROM ThongKe";
DataTable dt = DataProvider.ExecuteQuery(query);
foreach (DataRow dr in dt.Rows)
{
ThongKeDTO thongKeDTO = new ThongKeDTO();
thongKeDTO.MaHoatDong = Convert.ToInt32(dr["MaHoatDong"]);
thongKeDTO.TenHoatDong = dr["TenHoatDong"].ToString();
thongKeDTO.ChiPhi = (float)Convert.ToDouble(dr["ChiPhi"]);
listThongKeDTO.Add(thongKeDTO);
}
return(listThongKeDTO);
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
fAdmin f = new fAdmin();
ThongKeDTO obj = new ThongKeDTO();
obj.TenBang = f.LoadTenBangFromComboBox();
obj.Ngay = f.GetDay();
obj.MaNV = cmbTenNV.SelectedValue.ToString();
obj.MaDV = cmbTenDV.Text.ToString();
obj.TienCer = int.Parse(txbCertificat.Text.Trim());
obj.TienMat = int.Parse(txbTienMat.Text.Trim());
QLThemDichVuBUS _Service = new QLThemDichVuBUS();
obj.ThoiGianDV = _Service.GetThoiGian(cmbTenDV.Text.ToString());
_Service.ThemTua(obj);
//f.DataKhiChonNhanVien();
}
catch (Exception exp)
{
MessageBox.Show("Thêm bị lỗi: " + exp.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public bool ThemThongKe(ThongKeDTO TK)
{
return(ThongKeDAL.Instance.insertThongKe(TK));
}
public void ThemHoatDong(ThongKeDTO tkDTO)
{
thongKeDAO.ThemHoatDong(tkDTO);
}
public void SuaThongTin(ThongKeDTO kt)
{
thongKeDAO.SuaThongTin(kt);
}