public bool IsSerialBookResultExisted(string strCustomer_Id, string strBook_Number, DateTime dtFrom, DateTime dtTo) { bool result = false; using (Promotion.DataModel.SerialResult_BO objSerialResult_BO = new SerialResult_BO()) { List <Promotion.DataModel.SerialResult> lstData = objSerialResult_BO.GetByCustomer_idAndBook_numberAndInput_time(strCustomer_Id, strBook_Number, dtFrom, dtTo).ToList(); if (lstData != null && lstData.Count > 0) { result = true; } } return(result); }
public bool DeleteSerialBookByBookNumber(string strBook_Number, string strSavedBy, DateTime dtFrom, DateTime dtTo, ref string strResponse) { bool result = false; strResponse = string.Empty; using (Promotion.DataModel.SerialResult_BO objSerialResult_BO = new SerialResult_BO()) { DataModel.SerialResult objSerialResult = objSerialResult_BO.GetByBook_numberAndInput_time(strBook_Number, dtFrom, dtTo); if (objSerialResult != null) { string strSerials = objSerialResult.Serials; string[] Serials = null; if (strSerials.Length > 0) { strSerials = strSerials.Substring(0, strSerials.Length - 1); Serials = strSerials.Split("|".ToCharArray()); } else { ArrayList arrTmp = new ArrayList(); Serials = (string[])arrTmp.ToArray(typeof(string)); } log.Info(strSerials); using (Promotion.DataModel.DelSerial_BO objDelSerial_BO = new DelSerial_BO()) { for (int nIndex = 0; nIndex < Serials.Length; nIndex++) { DelSerial objDelSerial = new DelSerial(); objDelSerial.book_number = objSerialResult.book_number; objDelSerial.Serial = Serials[nIndex]; objDelSerial.input_time = DateTime.Now; objDelSerial.SavedBy = strSavedBy; objDelSerial_BO.CreateDelSerial(objDelSerial); log.Info(strBook_Number + ": Xóa " + Serials[nIndex]); } } objSerialResult.DeletedBy = strSavedBy; objSerialResult.DeletedDate = DateTime.Now; objSerialResult_BO.DeleteSerialResult(objSerialResult); result = true; } else { strResponse = string.Format("Số sổ {0} không tồn tại.", strBook_Number); log.Info(strResponse); } } return(result); }
public SerialBook GetSerialBookResultByBookNumber(string strBookNumber, DateTime dtFrom, DateTime dtTo) { SerialBook arr = new SerialBook(); using (DataModel.SerialResult_BO objSerialResult_BO = new SerialResult_BO()) { DataModel.SerialResult objSerialResult = objSerialResult_BO.GetByBook_numberAndInput_time(strBookNumber, dtFrom, dtTo); if (objSerialResult != null) { arr = ConvertTo(objSerialResult); } else { arr = null; } } return(arr); }
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); }