public ActionResult Update(string id)
{
//
IRepository<RightExec> repoRightExec = new RightExecRepository();
RightExec rightExec = repoRightExec.GetById(Convert.ToInt32(id)); //lay 1 quyen vào Id
//
IVFS_RightExecDetailCustomerRepository<VFS_RightExecDetailCustomer> repoVFS_RightExecDetailCustomer = new VFS_RightExecDetailCustomerRepository();
IList<VFS_RightExecDetailCustomer> listVFS_RightExecDetailCustomer = repoVFS_RightExecDetailCustomer.getListRightExecDetailCustomerFromIdRightExec(Convert.ToInt32(id));
//
ISecuritiesHistRepository iSecuritiesHistRepository = new SecuritiesHistRepository(); // lay so du chung khoan
IRepository<VFS_RightExecDetailCustomer> repoDetailCustomerRightExec = new VFS_RightExecDetailCustomerRepository();
//
if (listVFS_RightExecDetailCustomer.Count == 0 )
{
IList<SecuritiesHist> sHist = iSecuritiesHistRepository.getSecuritiesHistByStockCodeAndTransactionDate(rightExec.StockCode, rightExec.DateOwnerConfirm);
foreach (var item in sHist)
{
VFS_RightExecDetailCustomer itemInsert = new VFS_RightExecDetailCustomer();
itemInsert.IdRightExec = rightExec.Id;
itemInsert.StockCode = rightExec.StockCode;
itemInsert.StockType = rightExec.StockType;
itemInsert.BoardType = rightExec.BoardType;
itemInsert.DateNoRight = rightExec.DateNoRight;
itemInsert.DateOwnerConfirm = rightExec.DateOwnerConfirm;
itemInsert.DatePay = rightExec.DatePay;
itemInsert.BeginRegisterDate = rightExec.BeginRegisterDate;
itemInsert.EndRegisterDate = rightExec.EndRegisterDate;
itemInsert.EndTransferDate = rightExec.EndTransferDate;
itemInsert.Description = rightExec.Description;
itemInsert.RateA = rightExec.RateA;
itemInsert.RateB = rightExec.RateB;
itemInsert.RightType = rightExec.RightType;
itemInsert.Difference = rightExec.Difference;
itemInsert.Posted = rightExec.Posted;
itemInsert.RightExecPrice = rightExec.RightExecPrice;
itemInsert.RoundType = rightExec.RoundType;
itemInsert.RoundPrice = rightExec.RoundPrice;
itemInsert.BranchCode = item.BranchCode;
itemInsert.BankGl = item.BankGl;
itemInsert.SectionGl = item.SectionGl;
itemInsert.AccountId = item.AccountId;
itemInsert.AccountName = item.AccountName;
itemInsert.StockCodeCurrent = item.StockCode;
itemInsert.QuantityCurrent = item.Quantity;
itemInsert.PendingDebitQuantity = item.PendingDebitQuantity;
itemInsert.TransactionDate = item.TransactionDate;
repoDetailCustomerRightExec.Save(itemInsert);
}
}
else
{
foreach (var item in listVFS_RightExecDetailCustomer)
{
item.DatePay = rightExec.DatePay;
repoDetailCustomerRightExec.Update(item);
}
}
ViewBag.Message = "Cập nhật quyền";
return RedirectToAction("Index");
}
public static void syncQuyen()
{
IRepository<SecuritiesHist> repoSecuritieshist = new SecuritiesHistRepository();
IRepository<RightExec> repoExec = new RightExecRepository();
ISecuritiesHistRepository iSecuritiesHistRepository = new SecuritiesHistRepository();
iSecuritiesHistRepository.truncateTable();
//IList<SecuritiesHist> listSecuritiesHist = repoSecuritieshist.GetAll();
IList<RightExec> listRightExec = repoExec.GetAll();
IRepository<VFS_RightExecDetailCustomer> repoDetailCustomerRightExec = new VFS_RightExecDetailCustomerRepository();
foreach (var item in listRightExec)
{
IList<SecuritiesHist> sHist = iSecuritiesHistRepository.getSecuritiesHistByStockCodeAndTransactionDate(item.StockCode, item.DateOwnerConfirm);
if (sHist.Count > 0)
{
foreach (var itemHist in sHist)
{
VFS_RightExecDetailCustomer itemInsert = new VFS_RightExecDetailCustomer();
itemInsert.IdRightExec = item.Id;
itemInsert.StockCode = item.StockCode;
itemInsert.StockType = item.StockType;
itemInsert.BoardType = item.BoardType;
itemInsert.DateNoRight = item.DateNoRight;
itemInsert.DateOwnerConfirm = item.DateOwnerConfirm;
itemInsert.DatePay = item.DatePay;
itemInsert.BeginRegisterDate = item.BeginRegisterDate;
itemInsert.EndRegisterDate = item.EndRegisterDate;
itemInsert.EndTransferDate = item.EndTransferDate;
itemInsert.Description = item.Description;
itemInsert.RateA = item.RateA;
itemInsert.RateB = item.RateB;
//if (item.RightType == "S")
//{
// itemInsert.RightType = "K";
//}
//else
//{//K = stock
itemInsert.RightType = item.RightType;
//}
itemInsert.Difference = item.Difference;
itemInsert.Posted = item.Posted;
itemInsert.RightExecPrice = item.RightExecPrice;
itemInsert.RoundType = item.RoundType;
itemInsert.RoundPrice = item.RoundPrice;
itemInsert.BranchCode = itemHist.BranchCode;
itemInsert.BankGl = itemHist.BankGl;
itemInsert.SectionGl = itemHist.SectionGl;
itemInsert.AccountId = itemHist.AccountId;
itemInsert.AccountName = itemHist.AccountName;
itemInsert.StockCodeCurrent = itemHist.StockCode;
itemInsert.QuantityCurrent = itemHist.Quantity;
itemInsert.PendingDebitQuantity = itemHist.PendingDebitQuantity;
itemInsert.TransactionDate = itemHist.TransactionDate;
repoDetailCustomerRightExec.Save(itemInsert);
}
}
}
}
public ActionResult Sync()
{
ViewBag.Message = "Your contact page.";
IRepository<SecuritiesHist> repoSecuritieshist = new SecuritiesHistRepository();
IRepository<RightExec> repoExec = new RightExecRepository();
ISecuritiesHistRepository iSecuritiesHistRepository = new SecuritiesHistRepository();
//IList<SecuritiesHist> listSecuritiesHist = repoSecuritieshist.GetAll();
IList<RightExec> listRightExec = repoExec.GetAll();
IRepository<VFS_RightExecDetailCustomer> repoDetailCustomerRightExec = new VFS_RightExecDetailCustomerRepository();
foreach (var item in listRightExec)
{
IList<SecuritiesHist> sHist = iSecuritiesHistRepository.getSecuritiesHistByStockCodeAndTransactionDate(item.StockCode, item.DateOwnerConfirm);
if (sHist.Count > 0)
{
foreach (var itemHist in sHist)
{
VFS_RightExecDetailCustomer itemInsert = new VFS_RightExecDetailCustomer();
itemInsert.IdRightExec = item.Id;
itemInsert.StockCode = item.StockCode;
itemInsert.StockType = item.StockType;
itemInsert.BoardType = item.BoardType;
itemInsert.DateNoRight = item.DateNoRight;
itemInsert.DateOwnerConfirm = item.DateOwnerConfirm;
itemInsert.DatePay = item.DatePay;
itemInsert.BeginRegisterDate = item.BeginRegisterDate;
itemInsert.EndRegisterDate = item.EndRegisterDate;
itemInsert.EndTransferDate = item.EndTransferDate;
itemInsert.Description = item.Description;
itemInsert.RateA = item.RateA;
itemInsert.RateB = item.RateB;
itemInsert.RightType = item.RightType;
itemInsert.Difference = item.Difference;
itemInsert.Posted = item.Posted;
itemInsert.RightExecPrice = item.RightExecPrice;
itemInsert.RoundType = item.RoundType;
itemInsert.RoundPrice = item.RoundPrice;
itemInsert.BranchCode = itemHist.BranchCode;
itemInsert.BankGl = itemHist.BankGl;
itemInsert.SectionGl = itemHist.SectionGl;
itemInsert.AccountId = itemHist.AccountId;
itemInsert.AccountName = itemHist.AccountName;
itemInsert.StockCodeCurrent = itemHist.StockCode;
itemInsert.QuantityCurrent = itemHist.Quantity;
itemInsert.PendingDebitQuantity = itemHist.PendingDebitQuantity;
itemInsert.TransactionDate = itemHist.TransactionDate;
repoDetailCustomerRightExec.Save(itemInsert);
}
}
}
return View();
}
