/// --------------------------------------------------------------------- /// <summary> /// Save Credit View /// </summary> /// <param name="detailItemView">DetailItemView</param> /// <returns>bool</returns> /// --------------------------------------------------------------------- public bool Save(DetailItemView detailItemView) { try { var credit = GetCredit(detailItemView.PkID, detailItemView.UserName); if (credit != null) { credit.Name = detailItemView.Name; credit.Amount = Convert.ToDecimal(detailItemView.StrAmount.Replace("$", "")); credit.FkPeriod = detailItemView.FkPeriod; credit.BeginDate = detailItemView.BeginDate; credit.EndDate = detailItemView.EndDate; credit.WeeklyDOW = (int?) detailItemView.WeeklyDOW; credit.EverOtherWeekDOW = (int?) detailItemView.EverOtherWeekDOW; credit.BiMonthlyDay1 = (int?) detailItemView.BiMonthlyDay1; credit.BiMonthlyDay2 = (int?) detailItemView.BiMonthlyDay2; credit.MonthlyDOM = (int?) detailItemView.MonthlyDOM; credit.Quarterly1Month = (int?) detailItemView.Quarterly1Month; credit.Quarterly1Day = (int?) detailItemView.Quarterly1Day; credit.Quarterly2Month = (int?) detailItemView.Quarterly2Month; credit.Quarterly2Day = (int?) detailItemView.Quarterly2Day; credit.Quarterly3Month = (int?) detailItemView.Quarterly3Month; credit.Quarterly3Day = (int?) detailItemView.Quarterly3Day; credit.Quarterly4Month = (int?) detailItemView.Quarterly4Month; credit.Quarterly4Day = (int?) detailItemView.Quarterly4Day; credit.SemiAnnual1Month = (int?) detailItemView.SemiAnnual1Month; credit.SemiAnnual1Day = (int?) detailItemView.SemiAnnual1Day; credit.SemiAnnual2Month = (int?) detailItemView.SemiAnnual2Month; credit.SemiAnnual2Day = (int?) detailItemView.SemiAnnual2Day; credit.AnnualMOY = (int?) detailItemView.AnnualMOY; credit.AnnualDOM = (int?) detailItemView.AnnualDOM; credit.DateRangeReq = detailItemView.DateRangeReq; credit.Period = detailItemView.Period; _db.Entry(credit).State = EntityState.Modified; _db.SaveChanges(); } else { throw new ArgumentNullException(); } return true; } catch (Exception ex) { return false; } }
/// --------------------------------------------------------------------- /// <summary> /// Get Credit View /// </summary> /// <param name="id">int?</param> /// <param name="userName">string</param> /// <returns>DetailItemView</returns> /// --------------------------------------------------------------------- public DetailItemView GetCreditView(int? id, string userName) { try { var credit = GetCredit(id, userName); if (credit != null) { var creditView = new DetailItemView { PkID = credit.PkCredit, UserName = credit.UserName, Name = credit.Name, StrAmount = credit.Amount.ToString(), FkPeriod = credit.FkPeriod, BeginDate = credit.BeginDate, EndDate = credit.EndDate, WeeklyDOW = (Weekday?) credit.WeeklyDOW, EverOtherWeekDOW = (Weekday?) credit.EverOtherWeekDOW, BiMonthlyDay1 = (DayOfMonth?) credit.BiMonthlyDay1, BiMonthlyDay2 = (DayOfMonth?) credit.BiMonthlyDay2, MonthlyDOM = (DayOfMonth?) credit.MonthlyDOM, Quarterly1Month = (Month?) credit.Quarterly1Month, Quarterly1Day = (DayOfMonth?) credit.Quarterly1Day, Quarterly2Month = (Month?) credit.Quarterly2Month, Quarterly2Day = (DayOfMonth?) credit.Quarterly2Day, Quarterly3Month = (Month?) credit.Quarterly3Month, Quarterly3Day = (DayOfMonth?) credit.Quarterly3Day, Quarterly4Month = (Month?) credit.Quarterly4Month, Quarterly4Day = (DayOfMonth?) credit.Quarterly4Day, SemiAnnual1Month = (Month?) credit.SemiAnnual1Month, SemiAnnual1Day = (DayOfMonth?) credit.SemiAnnual1Day, SemiAnnual2Month = (Month?) credit.SemiAnnual2Month, SemiAnnual2Day = (DayOfMonth?) credit.SemiAnnual2Day, AnnualMOY = (Month?) credit.AnnualMOY, AnnualDOM = (DayOfMonth?) credit.AnnualDOM, DateRangeReq = credit.DateRangeReq, Period = credit.Period }; return creditView; } throw new ArgumentNullException(); } catch (Exception ex) { return null; } }
/// --------------------------------------------------------------------- /// <summary> /// Add New Credit /// </summary> /// <param name="detailItemView">DetailItemView</param> /// <returns>bool</returns> /// --------------------------------------------------------------------- public bool Add(DetailItemView detailItemView) { try { var credit = new Credit { UserName = detailItemView.UserName, Name = detailItemView.Name, Amount = Convert.ToDecimal(detailItemView.StrAmount.Replace("$", "")), FkPeriod = detailItemView.FkPeriod, BeginDate = detailItemView.BeginDate, EndDate = detailItemView.EndDate, WeeklyDOW = (int?) detailItemView.WeeklyDOW, EverOtherWeekDOW = (int?) detailItemView.EverOtherWeekDOW, BiMonthlyDay1 = (int?) detailItemView.BiMonthlyDay1, BiMonthlyDay2 = (int?) detailItemView.BiMonthlyDay2, MonthlyDOM = (int?) detailItemView.MonthlyDOM, Quarterly1Month = (int?) detailItemView.Quarterly1Month, Quarterly1Day = (int?) detailItemView.Quarterly1Day, Quarterly2Month = (int?) detailItemView.Quarterly2Month, Quarterly2Day = (int?) detailItemView.Quarterly2Day, Quarterly3Month = (int?) detailItemView.Quarterly3Month, Quarterly3Day = (int?) detailItemView.Quarterly3Day, Quarterly4Month = (int?) detailItemView.Quarterly4Month, Quarterly4Day = (int?) detailItemView.Quarterly4Day, SemiAnnual1Month = (int?) detailItemView.SemiAnnual1Month, SemiAnnual1Day = (int?) detailItemView.SemiAnnual1Day, SemiAnnual2Month = (int?) detailItemView.SemiAnnual2Month, SemiAnnual2Day = (int?) detailItemView.SemiAnnual2Day, AnnualMOY = (int?) detailItemView.AnnualMOY, AnnualDOM = (int?) detailItemView.AnnualDOM, DateRangeReq = detailItemView.DateRangeReq, Period = detailItemView.Period }; _db.Credits.Add(credit); _db.SaveChanges(); return true; } catch (Exception ex) { return false; } }