private void btnThem_Click(object sender, EventArgs e)
{
//bắt đk
if (usePhieugui.MaSTKLaNULL(txtMaSTK.Text))
{
MessageBox.Show("Mã Sổ tiết kiệm không được trống!", "Cảnh báo!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (usePhieugui.MaKHLaNULL(txtMaKH.Text))
{
MessageBox.Show("Mã khách hàng không được trống!", "Cảnh báo!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (usePhieugui.SoTienGuiLaNULL(txtSoTienGui.Text))
{
MessageBox.Show("số tiền gửi không được trống!", "Cảnh báo!", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
try
{
PhieuGui pg = new PhieuGui(txtMaPhieuGui.Text, txtMaSTK.Text, txtMaKH.Text, dateTimePicker1.Text, txtSoTienGui.Text);
usePhieugui.ThemPhieuGui(pg);
init();
gridPhieuGui.DataSource = usePhieugui.loadPhieuGui();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//throw;
}
}
}
public List <PhieuGui> LoadPhieuGuiByTime(string start, string end)
{
List <PhieuGui> list = new List <PhieuGui>();
string query = "SET DATEFORMAT DMY SELECT [MAPHIEU],[CMND],[MADV],[NGAYGUI],[LAISUAT],[KYHAN],[SOTIEN_GUI],[NGAYDENHAN],[MAGDV_LPG]FROM [QL_TAIKHOAN].[dbo].[PHIEUGUI] WHERE [NGAYGUI]>='" + start + "' AND [NGAYGUI]<='" + end + "'";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
PhieuGui phieu = new PhieuGui(item);
list.Add(phieu);
}
return(list);
}
public List <PhieuGui> LoadAllPhieuGuiByCMND(string cmnd)
{
List <PhieuGui> list = new List <PhieuGui>();
string query = "SELECT [MAPHIEU],[CMND],[MADV],[NGAYGUI],[LAISUAT],[KYHAN],[SOTIEN_GUI],[NGAYDENHAN],[MAGDV_LPG] FROM PHIEUGUI WHERE MAPHIEU NOT IN(SELECT MAPHIEU FROM PHIEURUT) AND CMND ='" + cmnd + "'";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
PhieuGui phieu = new PhieuGui(item);
list.Add(phieu);
}
return(list);
}
public List <PhieuGui> LoadAllPhieuGui()
{
List <PhieuGui> list = new List <PhieuGui>();
string query = "SELECT [MAPHIEU],[CMND],[MADV],[NGAYGUI],[LAISUAT], [KYHAN] ,[SOTIEN_GUI],[NGAYDENHAN],[MAGDV_LPG] FROM [QL_TAIKHOAN].[dbo].[PHIEUGUI] ORDER BY MAPHIEU DESC";
DataTable data = DataProvider.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
PhieuGui phieu = new PhieuGui(item);
list.Add(phieu);
}
return(list);
}
private void btnXoa_Click(object sender, EventArgs e)
{
try
{
PhieuGui pg = new PhieuGui(txtMaPhieuGui.Text, txtMaSTK.Text, txtMaKH.Text, dateTimePicker1.Text, txtSoTienGui.Text);
usePhieugui.XoaPhieuGui(pg);
init();
gridPhieuGui.DataSource = usePhieugui.loadPhieuGui();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
//throw;
}
}
//sửa
public void XoaPhieuGui(PhieuGui pg)
{
string sql = "delete from PhieuGoiTien where MaPhieuGoi = N'" + pg.MaPhieuGui + "'";
try
{
cnn = new SqlConnection(str);
cnn.Open();
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cnn.Close();
cnn.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
// throw;
}
}
//thêm
public void ThemPhieuGui(PhieuGui pg)
{
string sql = "insert into PhieuGoiTien values (N'" + pg.MaPhieuGui + "', N'" + pg.MaSTK + "', N'" +
pg.MaKH + "', '" + pg.ThoiGianGui.ToString("yyyy-MM-dd HH:mm:ss") + "', N'" + pg.SoTienGui + "') ";
try
{
cnn = new SqlConnection(str);
cnn.Open();
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.ExecuteNonQuery();
cmd.Dispose();
cnn.Close();
cnn.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
// throw;
}
}
private void cbxMaPhieu_SelectedValueChanged(object sender, EventArgs e)
{
ComboBox cb = sender as ComboBox;
if (cbxMaPhieu.SelectedItem == null)
{
return;
}
PhieuGui phieu = cbxMaPhieu.SelectedItem as PhieuGui;
try
{
if (phieu != null)
{
txtMaDV.Text = phieu.MaDV;
txtMoney.Text = Math.Round(phieu.SoTienGui, 0).ToString();
txtLaiSuat.Text = phieu.LaiSuat.ToString();
dateNgayGui.Value = Convert.ToDateTime(phieu.NgayGui);
dateNgayDenHan.Value = Convert.ToDateTime(phieu.NgayDenHan);
txtKyHan.Text = phieu.KyHan.ToString();
string maDV = phieu.MaDV;
try
{
DichvuLaisuat dvls = DichvuLaisuatDAO.Instance.LoadDVLSByMaDV(maDV);
txtTenDV.Text = dvls.TenDV;
}
catch
{
}
}
}
catch
{
}
txtTienLai.Text = "";
}
