public void TestMethod3()
{
RefDAL refDAL = new RefDAL();
var id = Guid.Parse("F98FA4A8-09E6-D403-1FF6-021EC8F4E5AF");
Assert.IsTrue(refDAL.DeleteRef(id));
}
public void TestMethod4()
{
RefDAL refDAL = new RefDAL();
List <Guid> id = new List <Guid>();
id.Add(Guid.Parse("97AECCCF-38E7-A8E6-4A5B-0137B4EB46D1"));
id.Add(Guid.Parse("666C3824-0105-9E5B-B86B-0226A45DB0D2"));
Assert.IsTrue(refDAL.DeleteRefs(id));
}
public void TestMethod1()
{
RefDAL refDAL = new RefDAL();
Ref r = new Ref();
var res = new RefDetail();
r.RefDetails = new List <RefDetail>();
// Thêm bẳng Ref
r.RefNo = "NK0000100"; //thêm mã hóa đơn
string iDate = "2005-05-05";
r.RefDate = DateTime.Parse(iDate); //ngày hóa đơn
r.JournalMemo = "Thái đẹp trai vl"; //mô tả hóa đơn
r.VendorID = Guid.Parse("E1D3EC06-B0B7-8A3A-2395-02BEE389761E"); // khởi tạo nhà cung cấp
r.EmployeeID = Guid.Parse("19D865A4-1CCD-0F2D-A757-0518E0B5E4A6"); //thêm mới nhân viên
//Thêm bảng RefDetails
res.InventoryItemID = Guid.Parse("1FC2F63C-08B1-7630-3858-00A0E7C57734"); // thêm mới danh sách sản phẩm
res.Quantity = 2;
res.Amount = 200;
res.DiscountRate = 3;
res.DiscountAmount = 4;
res.VATRate = 5;
res.VATAmount = 6;
res.StockID = Guid.Parse("3d277d90-eb0a-540e-34a5-48af2457c1e8");
r.RefDetails.Add(res);
res.InventoryItemID = Guid.Parse("8BD2AD59-23DA-79E8-BB5F-03FCEF7A0D8E"); // thêm mới danh sách sản phẩm
res.Quantity = 2;
res.Amount = 200;
res.DiscountRate = 3;
res.DiscountAmount = 4;
res.VATRate = 5;
res.StockID = Guid.Parse("3d277d90-eb0a-540e-34a5-48af2457c1e8");
res.VATAmount = 6;
r.RefDetails.Add(res);
Assert.IsTrue(refDAL.CreateInvoice(r));
}
/// <summary>
/// Kiểm tra refdetail rơi vào trường hợp nào r tiến hành thêm/sửa/xóa
/// </summary>
/// <param name="r"></param>
/// <returns></returns>
public bool CheckRefDetail(Ref r)
{
bool result = true;
List <Guid> listDelete = new List <Guid>();
RefDAL refDAL = new RefDAL();
try
{
// nếu không có refdetail nào đc gửi lên => user xóa hết refdetail, ta thực hiện hàm xóa hết refdetails by refID
if (r.RefDetails.Count <= 0)
{
DeleteAllRefDetail(r.RefID);
refDAL.UpdateRefTotalAmount(r.RefID, 0);
}
else
{
var list = GetRefDetailByIDRef(r.RefID); //Lấy ra những refdetail by refID trong DB
var count = list.Count;
if (count > 0)
{
foreach (var refID_DB in list.ToList()) // list refdetailID DB
{ //A D Z B
foreach (var ref_CL in r.RefDetails.ToList()) // list refdetailID CL
{
//A B
//Nếu có refdetail vẫn tồn tại, check xem có thay đổi gì không.
if (refID_DB == ref_CL.RefDetailID)
{
UpdateRefDetail(ref_CL.RefDetailID, ref_CL.InventoryItemID, ref_CL.Quantity, ref_CL.Amount, ref_CL.DiscountRate, ref_CL.DiscountAmount, ref_CL.VATRate, ref_CL.VATAmount, ref_CL.StockID);
var payamount = ReaderPayAmountRefDetail(r.RefID);
refDAL.UpdateRefTotalAmount(r.RefID, payamount);
int indexCL = r.RefDetails.IndexOf(ref_CL);
r.RefDetails.RemoveAt(indexCL);
int indexDB = list.IndexOf(refID_DB);
list.RemoveAt(indexDB);
break;
}
}
}
//Nếu list trong DB còn, ta xóa những refdetai k trùng trong DB
if (count > 0)
{
foreach (var item in list)
{
DeleteRefDetail(item);
}
}
//Nếu list trong CL còn, ta thực hiện thêm những refdetail người dùng mới thêm vào
if (r.RefDetails.Count > 0)
{
foreach (var CL in r.RefDetails.ToList())
{
InsertRefDetail(r.RefID, CL.InventoryItemID, CL.Quantity, CL.Amount, CL.DiscountRate, CL.DiscountAmount, CL.VATRate, CL.VATAmount, CL.StockID);
var payamount = ReaderPayAmountRefDetail(r.RefID);
refDAL.UpdateRefTotalAmount(r.RefID, payamount);
}
}
}
else
{
foreach (var CL in r.RefDetails)
{
InsertRefDetail(r.RefID, CL.InventoryItemID, CL.Quantity, CL.Amount, CL.DiscountRate, CL.DiscountAmount, CL.VATRate, CL.VATAmount, CL.StockID);
var payamount = ReaderPayAmountRefDetail(r.RefID);
refDAL.UpdateRefTotalAmount(r.RefID, payamount);
}
}
result = true;
}
}
catch (Exception)
{
result = false;
throw;
}
return(result);
}
/// <summary>
/// Kiểm tra trung RefNo trong DB
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool CheckRefNo(string id)
{
RefDAL refDAL = new RefDAL();
return(refDAL.CheckRefNo(id));
}
/// <summary>
/// Lấy ra Ref by Date
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IEnumerable <Ref> GetRefByDate(DateTime[] id)
{
RefDAL refDAL = new RefDAL();
return(refDAL.GetEntities(id));
}
/// <summary>
/// Lấy ra Ref by id
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Ref GetRefByID(object[] id)
{
RefDAL refDAL = new RefDAL();
return(refDAL.GetEntity("[dbo].[Proc_GetRefByIDDiaLogShow]", id));
}
/// <summary>
/// Update Bảng Ref
/// </summary>
/// <param name="JournalMemo"></param>
/// <param name="EmployeeID"></param>
/// <param name="ContactName"></param>
/// <param name="RefNo"></param>
/// <returns></returns>
public bool UpdateRef(string JournalMemo, Guid EmployeeID, string ContactName, string RefNo)
{
RefDAL refDAL = new RefDAL();
return(refDAL.Update_Ref(JournalMemo, EmployeeID, ContactName, RefNo));
}
/// <summary>
/// Tạo mới Phiếu
/// </summary>
/// <param name="invoice"></param>
/// <returns></returns>
public bool CreateInvoice(Ref invoice)
{
RefDAL refDAL = new RefDAL();
return(refDAL.CreateInvoice(invoice));
}
/// <summary>
/// Lấy dữ liệu của bảng Ref tầng BL
/// </summary>
/// <param name="a"></param>
/// <returns></returns>
///
//public IEnumerable<Ref> GetDataRef()
//{
// BaseBL<Ref> baseBL = new BaseBL<Ref>();
// return baseBL.GetData("[dbo].[Proc_GetRefsFull]");
//}
public IEnumerable <Ref> GetDataRef()
{
RefDAL refDAL = new RefDAL();
return(refDAL.Get());
}
/// <summary>
/// Xóa nhiều ref
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteEntitys(List <Guid> id)
{
RefDAL refDAL = new RefDAL();
return(refDAL.DeleteRefs(id));
}
/// <summary>
/// Xóa Ref theo RefID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteEntity(Guid id)
{
RefDAL refDAL = new RefDAL();
return(refDAL.DeleteRef(id));
}
public void TestMethod2()
{
RefDAL refDAL = new RefDAL();
Assert.IsTrue(refDAL.CheckRefNo("NK0000200"));
}