//public SerialBook GetSerialBookFromT24(string strBookNumber, string strHost, string strPort, string strService, string strUserId, string strPwd, string strSchema, string strBOOK_TYPE, string strCIF, ref string strCategory)
public SerialBook GetSerialBookFromT24(string strBookNumber, string strBOOK_TYPE, string strCIF, ref string strCategory)
{
SerialBook oBook = null;
using (PromotionEntities db = new PromotionEntities())
{
bool bResult = false;
string strResponse = string.Empty;
try
{
//string strAZCommandText = "SELECT ID,PASSBOOK.NUMBER,CUSTOMER,CURRENCY,PRINCIPAL,VALUE.DATE,MATURITY.DATE,CO.CODE,TERM FROM " + strSchema + ".";
//strAZCommandText += "FBNK_AZ_ACCOUNT WHERE PASSBOOK.NUMBER='" + strBookNumber + "'";
//string strLDCommandText = "SELECT ID,CONTRACT.NO,CUSTOMER.ID,CURRENCY,AMOUNT,VALUE.DATE,FIN.MAT.DATE,CO.CODE,TERM FROM " + strSchema + ".";
//strLDCommandText += "FBNK_LD_L002 WHERE CONTRACT.NO='" + strBookNumber + "'";
if (strBOOK_TYPE.ToUpper() == "AZ")
{
strResponse = string.Empty;
var lstAZByCustomerID = db.AZ_ACCOUNT.Where(t => t.CUSTOMER_ID.Equals(strCIF));
if(lstAZByCustomerID != null)
{
foreach (var azAccount in lstAZByCustomerID)
{
Commons.Convertion _oConvertion = new Commons.Convertion();
if (azAccount.PASSBOOK_NUMBER != null && azAccount.PASSBOOK_NUMBER == strBookNumber)
{
oBook = new SerialBook();
oBook.Book_Number = azAccount.PASSBOOK_NUMBER;
oBook.Customer_Id = azAccount.CUSTOMER_ID;
oBook.Currency = azAccount.CURRENCY;
oBook.TotalAmount = Convert.ToDouble(azAccount.PRINCIPAL);
oBook.ValueDate = Convert.ToDateTime(azAccount.VALUE_DATE);
oBook.MaturityDate = Convert.ToDateTime(azAccount.MATURITY_DATE);
oBook.ACCOUNT_NUMBER = azAccount.ACCOUNT_NUMBER;
oBook.CO_CODE = azAccount.CO_CODE;
if (azAccount.THAM_GIA_KM != null)
{
oBook.ThamGiaKM = azAccount.THAM_GIA_KM;
}
if (azAccount.TERM != null && !string.IsNullOrEmpty(azAccount.TERM))
{
oBook.TERM = azAccount.TERM;
}
strCategory = azAccount.CATEGORY;
//reset response
strResponse = string.Empty;
var objCust = db.CUSTOMERs.FirstOrDefault(t => t.CUSTOMER_CODE.Equals(oBook.Customer_Id));
if(objCust != null)
{
oBook.Customer_Name = objCust.CUSTOMER_NAME;
oBook.CMTND = objCust.LEGAL_ID;
oBook.Sector = objCust.SECTOR;
oBook.Telephone = objCust.TELEPHONE;
}
break;
}
}
}
}
else //LD
{
strResponse = string.Empty;
var objLD = db.AZ_ACCOUNT.SingleOrDefault(t => t.PASSBOOK_NUMBER.Equals(strBookNumber));
if(objLD != null)
{
Commons.Convertion _oConvertion = new Commons.Convertion();
oBook = new SerialBook();
oBook.Book_Number = objLD.PASSBOOK_NUMBER;
oBook.Customer_Id = objLD.CUSTOMER_ID;
oBook.Currency = objLD.CURRENCY;
oBook.TotalAmount = Convert.ToDouble(objLD.PRINCIPAL);
oBook.ValueDate = Convert.ToDateTime(objLD.VALUE_DATE);
oBook.MaturityDate = Convert.ToDateTime(objLD.MATURITY_DATE); ;
oBook.ACCOUNT_NUMBER = objLD.ACCOUNT_NUMBER;
oBook.CO_CODE = objLD.CO_CODE;
if (objLD.TERM != null && !string.IsNullOrEmpty(objLD.TERM))
{
oBook.TERM = objLD.TERM;
}
strCategory = objLD.CATEGORY;
//reset response
strResponse = string.Empty;
var objCust = db.CUSTOMERs.FirstOrDefault(t => t.CUSTOMER_CODE.Equals(oBook.Customer_Id));
if (objCust != null)
{
oBook.Customer_Name = objCust.CUSTOMER_NAME;
oBook.CMTND = objCust.LEGAL_ID;
oBook.Sector = objCust.SECTOR;
oBook.Telephone = objCust.TELEPHONE;
}
}
}
}
catch (Exception oExc)
{
log.Error(oExc.Message);
}
if (oBook != null)
{
oBook.Customer_Name = SplitT24CustomerName(oBook.Customer_Name);
TimeSpan ts = oBook.MaturityDate - oBook.ValueDate;
int nPeriod = (int)(ts.TotalDays / 30);
int nRemain = (int)(ts.TotalDays % 30);
if (nRemain >= 28) nPeriod++;
if (nPeriod > 0)
{
oBook.PeriodInWord = string.Format("{0} tháng.", nPeriod.ToString());
}
else
{
int nWeeks = nRemain / 7;
oBook.PeriodInWord = string.Format("{0} tuần.", nWeeks.ToString());
}
}
}
return oBook;
}
//public SerialBook GetSerialBookFromT24(string strBookNumber, string strHost, string strPort, string strService, string strUserId, string strPwd, string strSchema, string strBOOK_TYPE, string strCIF, ref string strCategory)
public SerialBook GetSerialBookFromT24(string strBookNumber, string strBOOK_TYPE, string strCIF, ref string strCategory)
{
SerialBook oBook = null;
using (PromotionEntities db = new PromotionEntities())
{
bool bResult = false;
string strResponse = string.Empty;
try
{
//string strAZCommandText = "SELECT ID,PASSBOOK.NUMBER,CUSTOMER,CURRENCY,PRINCIPAL,VALUE.DATE,MATURITY.DATE,CO.CODE,TERM FROM " + strSchema + ".";
//strAZCommandText += "FBNK_AZ_ACCOUNT WHERE PASSBOOK.NUMBER='" + strBookNumber + "'";
//string strLDCommandText = "SELECT ID,CONTRACT.NO,CUSTOMER.ID,CURRENCY,AMOUNT,VALUE.DATE,FIN.MAT.DATE,CO.CODE,TERM FROM " + strSchema + ".";
//strLDCommandText += "FBNK_LD_L002 WHERE CONTRACT.NO='" + strBookNumber + "'";
if (strBOOK_TYPE.ToUpper() == "AZ")
{
strResponse = string.Empty;
var lstAZByCustomerID = db.AZ_ACCOUNT.Where(t => t.CUSTOMER_ID.Equals(strCIF));
if (lstAZByCustomerID != null)
{
foreach (var azAccount in lstAZByCustomerID)
{
Commons.Convertion _oConvertion = new Commons.Convertion();
if (azAccount.PASSBOOK_NUMBER != null && azAccount.PASSBOOK_NUMBER == strBookNumber)
{
oBook = new SerialBook();
oBook.Book_Number = azAccount.PASSBOOK_NUMBER;
oBook.Customer_Id = azAccount.CUSTOMER_ID;
oBook.Currency = azAccount.CURRENCY;
oBook.TotalAmount = Convert.ToDouble(azAccount.PRINCIPAL);
oBook.ValueDate = Convert.ToDateTime(azAccount.VALUE_DATE);
oBook.MaturityDate = Convert.ToDateTime(azAccount.MATURITY_DATE);
oBook.ACCOUNT_NUMBER = azAccount.ACCOUNT_NUMBER;
oBook.CO_CODE = azAccount.CO_CODE;
if (azAccount.THAM_GIA_KM != null)
{
oBook.ThamGiaKM = azAccount.THAM_GIA_KM;
}
if (azAccount.TERM != null && !string.IsNullOrEmpty(azAccount.TERM))
{
oBook.TERM = azAccount.TERM;
}
strCategory = azAccount.CATEGORY;
//reset response
strResponse = string.Empty;
var objCust = db.CUSTOMERs.FirstOrDefault(t => t.CUSTOMER_CODE.Equals(oBook.Customer_Id));
if (objCust != null)
{
oBook.Customer_Name = objCust.CUSTOMER_NAME;
oBook.CMTND = objCust.LEGAL_ID;
oBook.Sector = objCust.SECTOR;
oBook.Telephone = objCust.TELEPHONE;
}
break;
}
}
}
}
else //LD
{
strResponse = string.Empty;
var objLD = db.AZ_ACCOUNT.SingleOrDefault(t => t.PASSBOOK_NUMBER.Equals(strBookNumber));
if (objLD != null)
{
Commons.Convertion _oConvertion = new Commons.Convertion();
oBook = new SerialBook();
oBook.Book_Number = objLD.PASSBOOK_NUMBER;
oBook.Customer_Id = objLD.CUSTOMER_ID;
oBook.Currency = objLD.CURRENCY;
oBook.TotalAmount = Convert.ToDouble(objLD.PRINCIPAL);
oBook.ValueDate = Convert.ToDateTime(objLD.VALUE_DATE);
oBook.MaturityDate = Convert.ToDateTime(objLD.MATURITY_DATE);;
oBook.ACCOUNT_NUMBER = objLD.ACCOUNT_NUMBER;
oBook.CO_CODE = objLD.CO_CODE;
if (objLD.TERM != null && !string.IsNullOrEmpty(objLD.TERM))
{
oBook.TERM = objLD.TERM;
}
strCategory = objLD.CATEGORY;
//reset response
strResponse = string.Empty;
var objCust = db.CUSTOMERs.FirstOrDefault(t => t.CUSTOMER_CODE.Equals(oBook.Customer_Id));
if (objCust != null)
{
oBook.Customer_Name = objCust.CUSTOMER_NAME;
oBook.CMTND = objCust.LEGAL_ID;
oBook.Sector = objCust.SECTOR;
oBook.Telephone = objCust.TELEPHONE;
}
}
}
}
catch (Exception oExc)
{
log.Error(oExc.Message);
}
if (oBook != null)
{
oBook.Customer_Name = SplitT24CustomerName(oBook.Customer_Name);
TimeSpan ts = oBook.MaturityDate - oBook.ValueDate;
int nPeriod = (int)(ts.TotalDays / 30);
int nRemain = (int)(ts.TotalDays % 30);
if (nRemain >= 28)
{
nPeriod++;
}
if (nPeriod > 0)
{
oBook.PeriodInWord = string.Format("{0} tháng.", nPeriod.ToString());
}
else
{
int nWeeks = nRemain / 7;
oBook.PeriodInWord = string.Format("{0} tuần.", nWeeks.ToString());
}
}
}
return(oBook);
}
