public static void SaveSummaryPayFeeDaily() { using (var db = new RentBikeEntities()) { try { var stores = db.Stores.Where(c => c.ACTIVE == true).ToList(); foreach (var store in stores) { List <CONTRACT_FULL_VW> listContract = GetWarningData(DateTime.Today.ToString(), string.Empty, store.ID).Where(c => c.OVER_DATE <= 50).ToList(); foreach (var contract in listContract) { if (db.SummaryPayFeeDailies.Any(c => c.PERIOD_DATE == DateTime.Today && c.STORE_ID == store.ID)) { continue; } SummaryPayFeeDaily sum = new SummaryPayFeeDaily(); sum.CONTRACT_ID = contract.ID; sum.CONTRACT_NO = contract.CONTRACT_NO; sum.CUSTOMER_NAME = contract.CUSTOMER_NAME; sum.PHONE = contract.PHONE; sum.RENT_TYPE_ID = contract.RENT_TYPE_ID; sum.RENT_TYPE_NAME = contract.RENT_TYPE_NAME; sum.PERIOD_DATE = DateTime.Today; sum.PAY_FEE = contract.FEE_PER_DAY; sum.PAY_TIME = contract.PAYED_TIME; sum.PAY_MESSAGE = contract.PERIOD_MESSAGE; sum.STORE_ID = contract.STORE_ID; sum.STORE_NAME = contract.STORE_NAME; sum.NOTE = contract.NOTE; sum.SEARCH_TEXT = contract.SEARCH_TEXT; sum.CREATED_DATE = DateTime.Now; sum.UPDATED_DATE = DateTime.Now; db.SummaryPayFeeDailies.Add(sum); } } db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Logger.Log(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { Logger.Log(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } } catch (Exception ex) { Logger.Log(ex.Message + Environment.NewLine + ex.StackTrace); } } }
public static void SaveSummaryPayFeeDaily() { using (var db = new RentBikeEntities()) { try { var stores = db.Stores.Where(c => c.ACTIVE == true).ToList(); foreach (var store in stores) { List<CONTRACT_FULL_VW> listContract = GetWarningData(DateTime.Today.ToString(), string.Empty, store.ID).Where(c => c.OVER_DATE <= 50).ToList(); foreach (var contract in listContract) { if (db.SummaryPayFeeDailies.Any(c => c.PERIOD_DATE == DateTime.Today && c.STORE_ID == store.ID)) continue; SummaryPayFeeDaily sum = new SummaryPayFeeDaily(); sum.CONTRACT_ID = contract.ID; sum.CONTRACT_NO = contract.CONTRACT_NO; sum.CUSTOMER_NAME = contract.CUSTOMER_NAME; sum.PHONE = contract.PHONE; sum.RENT_TYPE_ID = contract.RENT_TYPE_ID; sum.RENT_TYPE_NAME = contract.RENT_TYPE_NAME; sum.PERIOD_DATE = DateTime.Today; sum.PAY_FEE = contract.FEE_PER_DAY; sum.PAY_TIME = contract.PAYED_TIME; sum.PAY_MESSAGE = contract.PERIOD_MESSAGE; sum.STORE_ID = contract.STORE_ID; sum.STORE_NAME = contract.STORE_NAME; sum.NOTE = contract.NOTE; sum.SEARCH_TEXT = contract.SEARCH_TEXT; sum.CREATED_DATE = DateTime.Now; sum.UPDATED_DATE = DateTime.Now; db.SummaryPayFeeDailies.Add(sum); } } db.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Logger.Log(string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State)); foreach (var ve in eve.ValidationErrors) { Logger.Log(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage)); } } } catch (Exception ex) { Logger.Log(ex.Message + Environment.NewLine + ex.StackTrace); } } }