public void CreateSerialResult(SerialResult objSerialResult)
{
if (objSerialResult != null)
{
try
{
objSerialResult.IsUsed = true;
db.SerialResults.Add(objSerialResult);
db.SaveChanges();
}
catch (Exception ex)
{
log.Fatal(ex);
}
}
}
public void DeleteSerialResult(SerialResult objSerialResult)
{
if (objSerialResult != null)
{
try
{
SerialResult objTemp = db.SerialResults.FirstOrDefault(o => o.id == objSerialResult.id && o.book_number == objSerialResult.book_number);
if (objTemp != null)
{
objTemp.IsUsed = false;
objTemp.DeletedDate = DateTime.Now;
objTemp.DeletedBy = objSerialResult.DeletedBy;
//db.SerialResults.Remove(objTemp);
db.SaveChanges();
}
}
catch (Exception ex)
{
log.Fatal(ex);
}
}
}
public void DeleteSerialResult(SerialResult objSerialResult)
{
if (objSerialResult != null)
{
try
{
SerialResult objTemp = db.SerialResults.FirstOrDefault(o => o.id == objSerialResult.id && o.book_number == objSerialResult.book_number);
if (objTemp != null)
{
objTemp.IsUsed = false;
objTemp.DeletedDate = DateTime.Now;
objTemp.DeletedBy = objSerialResult.DeletedBy;
//db.SerialResults.Remove(objTemp);
db.SaveChanges();
}
}
catch (Exception ex)
{
log.Fatal(ex);
}
}
}
public bool SaveSerialBook(string strUserName, SerialBook oBook, DateTime dtStart, DateTime dtEnd, ref string strResponse)
{
bool result = false;
if (oBook == null)
{
strResponse = "Dữ liệu không phù hợp";
}
else
{
if (IsSerialBookResultExisted(oBook.Customer_Id, oBook.Book_Number, dtStart, dtEnd))
{
strResponse = string.Format("Số sổ book_number {0} của khách hàng {1} đã tồn tại!", oBook.Customer_Id, oBook.Book_Number);
log.Info(strResponse);
}
else
{
try
{
string strSerials = string.Empty;
foreach (string str in oBook.Masoduthuongs)
{
strSerials += str + "|";
}
int nSeq = 0;
using (Promotion.DataModel.LuckySerial_BO objLuckySerial_BO = new LuckySerial_BO())
{
List<Promotion.DataModel.LuckySerial> lstData = objLuckySerial_BO.GetByInputTime(dtStart, dtEnd).ToList();
if (lstData != null && lstData.Count > 0)
{
nSeq = lstData.Count;
}
}
nSeq++;
using (Promotion.DataModel.SerialResult_BO objSerialResult_BO = new SerialResult_BO())
{
Promotion.DataModel.SerialResult objSerialResult = new SerialResult();
objSerialResult.book_number = oBook.Book_Number;
objSerialResult.customer_id = oBook.Customer_Id;
objSerialResult.customer_name = oBook.Customer_Name;
objSerialResult.CMND = oBook.CMTND;
objSerialResult.tel = oBook.Telephone;
objSerialResult.amount = oBook.TotalAmount;
objSerialResult.kyhan = oBook.Period;
objSerialResult.currency = oBook.Currency;
objSerialResult.Serials = strSerials;
objSerialResult.Input_time = DateTime.Now;
objSerialResult.SavedBy = strUserName;
objSerialResult.EFFECT_DATE = oBook.ValueDate;
objSerialResult.MATURITY_DATE = oBook.MaturityDate;
objSerialResult.Sector = oBook.Sector;
objSerialResult.ACCT_NUM = oBook.ACCOUNT_NUMBER;
objSerialResult.CO_CODE = oBook.CO_CODE;
objSerialResult.TERM = oBook.TERM;
objSerialResult.Seq = nSeq;
objSerialResult.DAO_CODE = oBook.DAO_CODE;
objSerialResult.DEPT_CODE = oBook.DEPT_CODE;
//objSerialResult.cMoney = oBook.TERM;
objSerialResult_BO.CreateSerialResult(objSerialResult);
}
log.Info(strSerials);
result = true;
}
catch (Exception ex)
{
log.Fatal(ex);
}
}
}
return result;
}
public void CreateSerialResult(SerialResult objSerialResult)
{
if (objSerialResult != null)
{
try
{
objSerialResult.IsUsed = true;
db.SerialResults.Add(objSerialResult);
db.SaveChanges();
}
catch (Exception ex)
{
log.Fatal(ex);
}
}
}