private void btTimKiem_Click(object sender, EventArgs e)
{
DMLoaiItemInfor dmLoaiItemInfor = new DMLoaiItemInfor();
dmLoaiItemInfor.TenLoaiItem = txtTenLoaiItem.Text;
dgvList.DataSource = DMLoaiItemDataProvider.Search(dmLoaiItemInfor);
}
public void TestLoaiItem07_DeleteSuccess()
{
TestLoaiItem05_InsertSuccess();
List <DMLoaiItemInfor> list = DMLoaiItemDataProvider.GetListItemInfor();
DMLoaiItemInfor infor = list.Find(delegate(DMLoaiItemInfor match)
{
return(match.MaLoaiItem == "5");
});
frmDM_LoaiItem frm = new frmDM_LoaiItem();
frm.isAdd = false;
frm.Oid = infor.IdLoaiItem;
frmChiTiet_LoaiItem frmChiTietLoaiItem = new frmChiTiet_LoaiItem(frm);
frmChiTietLoaiItem.TestDelete();
list = DMLoaiItemDataProvider.GetListItemInfor();
infor = list.Find(delegate(DMLoaiItemInfor match)
{
return(match.MaLoaiItem == "5");
});
Assert.AreEqual(infor, null);
}
internal int Insert(DMLoaiItemInfor dmLoaiItemInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiItemInsert);
SetParams(dmLoaiItemInfor);
Parameters["@IdLoaiItem"].Direction = ParameterDirection.Output;
ExecuteNoneQuery();
return(Convert.ToInt32(Parameters["@IdLoaiItem"].Value.ToString()));
}
internal bool Exist(DMLoaiItemInfor dmLoaiItemInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiItemExist);
Parameters.AddWithValue("@Count", 0).Direction = ParameterDirection.Output;
Parameters.AddWithValue("@IdLoaiItem", dmLoaiItemInfor.IdLoaiItem);
Parameters.AddWithValue("@MaLoaiItem", dmLoaiItemInfor.MaLoaiItem);
ExecuteNoneQuery();
return(Convert.ToInt32(Parameters["@Count"].Value) == 1);
}
private DMLoaiItemInfor getinfor()
{
DMLoaiItemInfor dmLoaiItemInfor = new DMLoaiItemInfor();
dmLoaiItemInfor.MaLoaiItem = txtMaLoaiItem.Text;
dmLoaiItemInfor.TenLoaiItem = txtTenLoaiItem.Text;
dmLoaiItemInfor.GhiChu = txtGhiChu.Text;
dmLoaiItemInfor.SuDung = Convert.ToInt32(cbSuDung.Checked);
dmLoaiItemInfor.IdLoaiItem = Convert.ToInt32(getValue("clIdLoaiItem"));
return(dmLoaiItemInfor);
}
public void TestLoaiItem03_MaLoaiItemHasExistedOnUpdate()
{
try
{
TestLoaiItem05_InsertSuccess();
List <DMLoaiItemInfor> list = DMLoaiItemDataProvider.GetListItemInfor();
DMLoaiItemInfor infor = list.Find(delegate(DMLoaiItemInfor match)
{
return(match.MaLoaiItem == "5");
});
frmDM_LoaiItem frm = new frmDM_LoaiItem();
frm.isAdd = false;
frm.Oid = infor.IdLoaiItem;
frmChiTiet_LoaiItem frmChiTietLoaiItem = new frmChiTiet_LoaiItem(frm);
frmChiTietLoaiItem.SetInput("LoaiItem1", "1", "Unit test ma LoaiItem", 1);
frmChiTietLoaiItem.TestSave();
list = DMLoaiItemDataProvider.GetListItemInfor();
List <DMLoaiItemInfor> listDuplicate = list.FindAll(delegate(DMLoaiItemInfor match)
{
return(match.MaLoaiItem == "1");
});
frmChiTietLoaiItem.TestDelete();
Assert.AreEqual(1, listDuplicate.Count);
}
catch (Exception ex)
{
if (ex.GetType() != typeof(AssertFailedException))
{
Assert.AreEqual(ex.Message, "Mã loại Item đã có trong hệ thống !");
}
else
{
throw;
}
}
}
internal List <DMLoaiItemInfor> Search(DMLoaiItemInfor dmLoaiItemInfor)
{
CreateGetListCommand(Declare.StoreProcedureNamespace.spLoaiItemSearch);
Parameters.AddWithValue("@MaLoaiItem", dmLoaiItemInfor.MaLoaiItem);
return(FillToList <DMLoaiItemInfor>());
}
internal void Delete(DMLoaiItemInfor dmLoaiItemInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiItemDelete);
Parameters.AddWithValue("@IdLoaiItem", dmLoaiItemInfor.IdLoaiItem);
ExecuteNoneQuery();
}
internal void Update(DMLoaiItemInfor dmLoaiItemInfor)
{
CreateCommonCommand(Declare.StoreProcedureNamespace.spLoaiItemUpdate);
SetParams(dmLoaiItemInfor);
ExecuteNoneQuery();
}
public static bool Kiemtra(DMLoaiItemInfor dmLoaiItemInfor)
{
return(DmLoaiItemDAO.Instance.Exist(dmLoaiItemInfor));
}
public static List <DMLoaiItemInfor> Search(DMLoaiItemInfor dmLoaiItemInfor)
{
return(DmLoaiItemDAO.Instance.Search(dmLoaiItemInfor));
}
internal static void Update(DMLoaiItemInfor dmLoaiItemInfor)
{
DmLoaiItemDAO.Instance.Update(dmLoaiItemInfor);
}
public static void Delete(DMLoaiItemInfor dmLoaiItemInfor)
{
DmLoaiItemDAO.Instance.Delete(dmLoaiItemInfor);
}
internal static void Insert(DMLoaiItemInfor dmLoaiItemInfor)
{
DmLoaiItemDAO.Instance.Insert(dmLoaiItemInfor);
}
private bool Search(DMLoaiItemInfor dmLoaiItemInfor)
{
return((txtTenLoiSearch.Text.Trim() == String.Empty || (txtTenLoiSearch.Text.Trim() != String.Empty &&
dmLoaiItemInfor.MaLoaiItem.ToLower().Contains(txtTenLoiSearch.Text.Trim().ToLower()))));
}
private bool Exist(DMLoaiItemInfor dmLoaiItemInfor)
{
return(dmLoaiItemInfor.MaLoaiItem.ToLower() == txtMaLoaiItem.Text.Trim().ToLower());
}
