public void TestLoaiThuChi07_DeleteSuccess()
{
TestLoaiThuChi05_InsertSuccess();
List <DMLoaiThuChiInfor> list = DMLoaiThuChiDataProvider.GetListLoaiThuChiInfor();
DMLoaiThuChiInfor infor = list.Find(delegate(DMLoaiThuChiInfor match)
{
return(match.KyHieu == "1111D");
});
frmDM_LoaiThuChi frm = new frmDM_LoaiThuChi();
frm.isAdd = false;
frm.Oid = infor.IdThuChi;
frmChiTiet_LoaiThuChi frmChiTietLoaiThuChi = new frmChiTiet_LoaiThuChi(frm);
frmChiTietLoaiThuChi.TestDelete();
list = DMLoaiThuChiDataProvider.GetListLoaiThuChiInfor();
infor = list.Find(delegate(DMLoaiThuChiInfor match)
{
return(match.KyHieu == "1111D");
});
Assert.AreEqual(infor, null);
}
private void Loaddata()
{
if (frmDMLoaiThuChi.isAdd)
{
Reset();
btnDelete.Enabled = false;
}
else
{
txtKyHieu.Enabled = false;
dm = DMLoaiThuChiDataProvider.GetListDmThuChiInfoFromOid(frmDMLoaiThuChi.Oid);
txtTen.Text = dm.Ten;
txtKyHieu.Text = dm.KyHieu;
txtGhiChu.Text = dm.GhiChu;
txtType.Text = Convert.ToString(dm.Type);
chkSuDung.Checked = dm.SuDung == 1;
}
if (frmDMLoaiThuChi.IsSync)
{
//không cho phép người dùng sửa, xóa các thông tin trên form.
txtKyHieu.Enabled = false;
txtTen.Enabled = false;
btnDelete.Enabled = false;
}
}
internal List <DMLoaiThuChiInfor> Search(DMLoaiThuChiInfor dmLoaiThuChiInfor)
{
CreateGetListCommand(Declare.StoreProcedureNamespace.spLoaiThuChiSearch);
Parameters.AddWithValue("@KyHieu", dmLoaiThuChiInfor.KyHieu);
Parameters.AddWithValue("@Ten", dmLoaiThuChiInfor.Ten);
return(FillToList <DMLoaiThuChiInfor>());
}
internal void Update(DMLoaiThuChiInfor dmLoaiThuChiInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiThuChiUpdate);
SetParams(dmLoaiThuChiInfor);
//Parameters["IdThuChi"].Direction = ParameterDirection.Output;
ExecuteNoneQuery();
//return Convert.ToInt32(Parameters["@IdThuChi"].Value.ToString());
}
private void LoadThoiHanThanhToan()
{
ThoiHanTTSelected = DMLoaiThuChiDataProvider.GetListDmThuChiInfoFromOid(Declare.IdThoiHanThanhToan);
if (ThoiHanTTSelected != null)
{
bteThoiHanThanhToan.Text = ThoiHanTTSelected.Ten;
bteThoiHanThanhToan.Tag = ThoiHanTTSelected;
}
}
internal bool Exist(DMLoaiThuChiInfor dmLoaiThuChiInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiThuChiExist);
Parameters.AddWithValue("@Count", 0).Direction = ParameterDirection.Output;
Parameters.AddWithValue("@IdThuChi", dmLoaiThuChiInfor.IdThuChi);
Parameters.AddWithValue("@KyHieu", dmLoaiThuChiInfor.KyHieu);
ExecuteNoneQuery();
return(Convert.ToInt32(Parameters["@Count"].Value) == 1);
}
private DMLoaiThuChiInfor SetDanhMuc()
{
DMLoaiThuChiInfor dm = new DMLoaiThuChiInfor();
dm.IdThuChi = Convert.ToInt32(frmDMLoaiThuChi.Oid);
dm.Ten = txtTen.Text.Trim();
dm.KyHieu = txtKyHieu.Text.Trim();
dm.GhiChu = txtGhiChu.Text.Trim();
dm.Type = Convert.ToInt32(txtType.Text.Trim());
dm.SuDung = Convert.ToInt32(chkSuDung.Checked);
return(dm);
}
private DMLoaiThuChiInfor getinfor()
{
DMLoaiThuChiInfor dmLoaiThuChiInfor = new DMLoaiThuChiInfor();
dmLoaiThuChiInfor.Ten = txtTen.Text;
dmLoaiThuChiInfor.KyHieu = txtMa.Text;
dmLoaiThuChiInfor.GhiChu = txtMoTa.Text;
dmLoaiThuChiInfor.Type = cboType.SelectedIndex;
dmLoaiThuChiInfor.SuDung = Convert.ToInt32(chkSuDung.Checked);
dmLoaiThuChiInfor.IdThuChi = Convert.ToInt32(getValue("clIdThuChi"));
return(dmLoaiThuChiInfor);
}
//private void LoadNganHang()
//{
// liNganHangTT = DMNganHangDataProvider.Instance.GetListNganHangInfors();
// cboNganHangTT.DataSource = liNganHangTT;
// cboNganHangTT.DisplayMember = "TenNganHang";
// cboNganHangTT.ValueMember = "IdNganHang";
// DMNganHangInfor[] t = new DMNganHangInfor[liNganHangTT.Count];
// liNganHangTT.CopyTo(t);
// liNganHangPH = new List<DMNganHangInfor>(t);
// //liNganHangPH = DMNganHangDataProvider.Instance.GetListNganHangInfors();
// cboNganHangPH.DataSource = liNganHangPH;
// cboNganHangPH.DisplayMember = "TenNganHang";
// cboNganHangPH.ValueMember = "IdNganHang";
//}
//private void LoadTaiKhoanQuy()
//{
// liTaiKhoanQuy = DMTaiKhoanQuyDataProvider.Instance.GetListTaiKhoanQuyByTrungTam(-1);
// cboTaiKhoanQuy.DataSource = liTaiKhoanQuy;
// cboTaiKhoanQuy.DisplayMember = "TaiKhoanQuy";
// cboTaiKhoanQuy.ValueMember = "TaiKhoanQuy";
//}
private void LoadThoiHanThanhToan()
{
int idThoiHanTT = ThanhToan.IdThoiHanThanhToan == 0
? Declare.IdThoiHanThanhToan
: ThanhToan.IdThoiHanThanhToan;
DMLoaiThuChiInfor dmLoaiThuChi = DMLoaiThuChiDataProvider.GetListDmThuChiInfoFromOid(idThoiHanTT);
if (dmLoaiThuChi != null)
{
bteThoiHanThanhToan.Text = dmLoaiThuChi.Ten;
bteThoiHanThanhToan.Tag = dmLoaiThuChi;
}
}
internal int Insert(DMLoaiThuChiInfor dmLoaiThuChiInfor)
{
//ExecuteCommand(Declare.StoreProcedureNamespace.spLoaiThuChiInsert, dmLoaiThuChiInfor.KyHieu,
// dmLoaiThuChiInfor.Ten, dmLoaiThuChiInfor.GhiChu, dmLoaiThuChiInfor.Type,
// dmLoaiThuChiInfor.SuDung);
// Common.IntValue(Parameters["p_IdThuChi"].Value.ToString());
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiThuChiInsert);
SetParams(dmLoaiThuChiInfor);
Parameters["@IdThuChi"].Direction = ParameterDirection.Output;
//Parameters["@IDORDERTYPE"].Direction = ParameterDirection.Output;
ExecuteNoneQuery();
return(Convert.ToInt32(Parameters["@IdThuChi"].Value));
}
private void Insert()
{
if (_thuchiinfor == null)
{
_thuchiinfor = new DMLoaiThuChiInfor();
_thuchiinfor.KyHieu = View.KyHieu;
_thuchiinfor.Ten = View.Ten;
_thuchiinfor.GhiChu = View.GhiChu;
_thuchiinfor.Type = View.Type;
_thuchiinfor.SuDung = View.SuDung;
_thuchiinfor.IdThuChi = DmLoaiThuChiDAO.Instance.Insert(_thuchiinfor);
((List <DMLoaiThuChiInfor>)DSThoiHanThanhToanView.Instance.DataSource).Add(_thuchiinfor);
DSThoiHanThanhToanView.Instance.RefreshDataSource();
}
}
private void LoadLoaiThuChi()
{
try
{
DMLoaiThuChiInfor dmLoaiThuChi = DMLoaiThuChiDataProvider.GetListDmThuChiInfoFromOid(IdThoiHanTTSelected);
if (dmLoaiThuChi != null)
{
bteThoiHanThanhToan.Text = dmLoaiThuChi.Ten;
bteThoiHanThanhToan.Tag = dmLoaiThuChi;
}
}
catch (System.Exception ex)
{
#if DEBUG
MessageBox.Show("Lỗi ngoại lệ: " + ex.ToString(), Declare.titleError, MessageBoxButtons.OK, MessageBoxIcon.Error);
#else
MessageBox.Show("Lỗi ngoại lệ: " + ex.Message, Declare.titleError, MessageBoxButtons.OK, MessageBoxIcon.Error);
#endif
}
}
public void TestLoaiThuChi03_MaLoaiThuChiHasExistedOnUpdate()
{
try
{
TestLoaiThuChi05_InsertSuccess();
List <DMLoaiThuChiInfor> list = DMLoaiThuChiDataProvider.GetListLoaiThuChiInfor();
DMLoaiThuChiInfor infor = list.Find(delegate(DMLoaiThuChiInfor match)
{
return(match.KyHieu == "1111D");
});
frmDM_LoaiThuChi frm = new frmDM_LoaiThuChi();
frm.isAdd = false;
frm.Oid = infor.IdThuChi;
frmChiTiet_LoaiThuChi frmChiTietLoaiThuChi = new frmChiTiet_LoaiThuChi(frm);
frmChiTietLoaiThuChi.SetInput("Trả Chậm 1111 ngày", "111D", "Unit test LoaiThuChi", 0, 1);
frmChiTietLoaiThuChi.TestSave();
list = DMLoaiThuChiDataProvider.GetListLoaiThuChiInfor();
List <DMLoaiThuChiInfor> listDuplicate = list.FindAll(delegate(DMLoaiThuChiInfor match)
{
return(match.KyHieu == "111D");
});
frmChiTietLoaiThuChi.TestDelete();
Assert.AreEqual(1, listDuplicate.Count);
}
catch (Exception ex)
{
if (ex.GetType() != typeof(AssertFailedException))
{
Assert.AreEqual(ex.Message, "Ký hiệu đã tồn tại trong hệ thống!");
}
else
{
throw;
}
}
}
private bool Exist(DMLoaiThuChiInfor dmLoaiThuChiInfor)
{
return(dmLoaiThuChiInfor.IdThuChi != idThuChi &&
dmLoaiThuChiInfor.Ten != null && dmLoaiThuChiInfor.Ten.ToLower() == txtTen.Text.Trim().ToLower());
}
public static List <DMLoaiThuChiInfor> Search(DMLoaiThuChiInfor match)
{
return(DmLoaiThuChiDAO.Instance.Search(match));
}
public static void Delete(DMLoaiThuChiInfor dmLoaiThuChiInfo)
{
DmLoaiThuChiDAO.Instance.Delete(dmLoaiThuChiInfo);
}
internal static void Update(DMLoaiThuChiInfor dmLoaiThuChiInfo)
{
DmLoaiThuChiDAO.Instance.Update(dmLoaiThuChiInfo);
}
internal static void Insert(DMLoaiThuChiInfor dmLoaiThuChiInfo)
{
DmLoaiThuChiDAO.Instance.Insert(dmLoaiThuChiInfo);
}
internal static bool KiemTra(DMLoaiThuChiInfor dmLoaiThuChiInfo)
{
return(DmLoaiThuChiDAO.Instance.Exist(dmLoaiThuChiInfo));
}
private void GetData()
{
_thuchiinfor = View.thuchiinfor;
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (ValidData())
{
if (bteTrungTam.Tag != null)
{
TTamSelected = (DMTrungTamInfor)bteTrungTam.Tag;
}
if (bteKhoXuat.Tag != null)
{
KhoSelected = (DMKhoInfo)bteKhoXuat.Tag;
}
if (cboCurrentLoaiDT.SelectedIndex != -1)
{
LoaiDTSelected = liLoaiDT[cboCurrentLoaiDT.SelectedIndex];
}
if (bteKhachHang.Tag != null)
{
KHangSelected = (DMDoiTuongInfo)bteKhachHang.Tag;
}
if (bteTruongCa.Tag != null)
{
TruongCaSelected = (DMNhanVienInfo)bteTruongCa.Tag;
}
if (bteThuNgan.Tag != null)
{
ThuNganSelected = (DMNhanVienInfo)bteThuNgan.Tag;
}
if (bteThoiHanThanhToan.Tag != null)
{
ThoiHanTTSelected = (DMLoaiThuChiInfor)bteThoiHanThanhToan.Tag;
}
if (TypeReset == 1 || TypeReset == 2)
{
if (TTamSelected != null)
{
Declare.IdTrungTam = TTamSelected.IdTrungTam;
Declare.TenTrungTam = TTamSelected.TenTrungTam;
}
if (KhoSelected != null)
{
Declare.IdKho = KhoSelected.IdKho;
Declare.TenKho = KhoSelected.TenKho;
}
if (LoaiDTSelected != null)
{
Declare.IdLoaiKhachHang = LoaiDTSelected.IdLoaiDT;
}
if (KHangSelected != null)
{
Declare.IdKHMacDinh = KHangSelected.IdDoiTuong;
Declare.TenKhachHang = KHangSelected.TenDoiTuong;
}
Declare.IdThuNgan = ThuNganSelected != null ? ThuNganSelected.IdNhanVien : 0;
Declare.IdTruongCa = TruongCaSelected != null ? TruongCaSelected.IdNhanVien : 0;
Declare.IdThoiHanThanhToan = ThoiHanTTSelected != null ? ThoiHanTTSelected.IdThuChi : 0;
Declare.NgayLamViec = dtNgayLamViec.Value;
DateTime now = CommonProvider.Instance.GetSysDate();
if (KhoSelected.NgayDuDau.CompareTo(now) > 0)
{
Declare.NgayDuDau = KhoSelected.NgayDuDau;
}
else
{
Declare.NgayDuDau = now;
}
}
if (TypeReset == 2)
{
string formMacDinh = "";
if (choseForm && lueFormMacDinh.EditValue != null)
{
formMacDinh = lueFormMacDinh.EditValue.ToString();
}
NguoiDungDataProvider.SetKhoMacDinh(Declare.IdTrungTam, Declare.IdKho, Declare.IdLoaiKhachHang,
Declare.IdKHMacDinh, Declare.IdTruongCa,
Declare.IdThuNgan, Declare.IdThoiHanThanhToan,
nguoiDung.IdNguoiDung, formMacDinh);
}
if (this.frmParent != null)
{
foreach (Form frm in frmParent.MdiChildren)
{
frm.Close();
}
}
this.DialogResult = DialogResult.OK;
}
}
internal void Delete(DMLoaiThuChiInfor dmLoaiThuChiInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiThuChiDelete);
Parameters.AddWithValue("@IdThuChi", dmLoaiThuChiInfor.IdThuChi);
ExecuteNoneQuery();
}
