public ActionResult DeletePledge(int id) { var fr = new FinancialRepository(Settings.Default.ConStr); fr.DeletePledge(id); return(Json(id)); }
public ActionResult Pledge(Pledge pledge) { var fr = new FinancialRepository(Settings.Default.ConStr); fr.AddPledge(pledge); return(RedirectToAction("ViewMyActivity")); }
public ActionResult ViewMembers() { FinancialRepository fr = new FinancialRepository(Settings.Default.ConStr); IEnumerable <Member> members = fr.GetMembers(); return(View(members)); }
public EmitentModel(EmitentRepository emitentRepository, FinancialRepository financialRepository) { this._emitentRepository = emitentRepository; this._financialRepository = financialRepository; Messenger.Default.Register <LoadEmitentListMessage>(this, async(msg) => { IEnumerable <Emitent> emitentList = await this._emitentRepository.GetAll(); Messenger.Default.Send <EmitentListLoadedMessage>(new EmitentListLoadedMessage() { EmitentList = emitentList }); }); Messenger.Default.Register <LoadFinancialListMessage>(this, async(msg) => { IEnumerable <Financial> financialList = await this._financialRepository.GetByEmitentId(msg.EmitentId); Messenger.Default.Send <FinancialListLoadedMessage>(new FinancialListLoadedMessage() { FinancialList = financialList }); }); Messenger.Default.Register <SaveEmitentMessage>(this, (msg) => { Task <string> task = null; if (msg.Emitent.Id != 0) { task = this._emitentRepository.Update(msg.Emitent); } }); Messenger.Default.Register <SaveFinancialMessage>(this, (msg) => { Task <string> task = null; if (msg.Financial.Id != 0) { task = this._financialRepository.Update(msg.Financial); } if (msg.Financial.Id == 0) { task = this._financialRepository.Create(msg.Financial); } task.ContinueWith(t => { Messenger.Default.Send <SaveFinancialResultMeassage>(new SaveFinancialResultMeassage() { Result = t.Result }); }); }); }
public ActionResult UpdatePledge(int amount, int id) { var fr = new FinancialRepository(Settings.Default.ConStr); fr.UpdatePledge(amount, id); Pledge pledge = fr.GetPledge(id); decimal a = pledge.Amount; return(Json(a, JsonRequestBehavior.AllowGet)); }
public void Test_Load() { var data = new List <OHLCV>(); var factory = new SSDConnectionFactory(@"STEVE-PC\SQL_SSD", "Forexite"); var repo = new FinancialRepository(factory); // CANNOT ACTUALLY INSERT //repo.Insert(Periods.OneMinute, new Pair(Symbol.NotSet, Symbol.NotSet), data); }
public ActionResult AddExpense(Expense expense) { if (expense.Name == null) { return(RedirectToAction("addexpense")); } var repo = new FinancialRepository(Settings.Default.ConStr); repo.AddExpense(expense); TempData["Notify"] = $"{expense.Name} added to expenses"; return(RedirectToAction("addexpense")); }
public ActionResult ViewMonthlyPayments(int expenseId, string expenseName) { ViewBag.expensename = expenseName; FinancialRepository fr = new FinancialRepository(Settings.Default.ConStr); IEnumerable <MonthlyPayment> monthlyPayments = fr.GetMonthlyPaymentsByExpenseId(expenseId); IEnumerable <MonthlyPaymentWithName> mpwn = monthlyPayments.Select(mp => new MonthlyPaymentWithName { Amount = mp.Amount, Name = mp.Member.FirstName + " " + mp.Member.LastName, Count = mp.Count.Value }); return(View(mpwn)); }
public ActionResult ViewPledges(int expenseId, string expenseName) { ViewBag.expensename = expenseName; FinancialRepository fr = new FinancialRepository(Settings.Default.ConStr); IEnumerable <Pledge> payments = fr.GetPledgesByExpenseId(expenseId); IEnumerable <PledgeWithName> pwn = payments.Select(p => new PledgeWithName { Amount = p.Amount, Date = p.Date, Name = p.Member.FirstName + " " + p.Member.LastName }); return(View(pwn)); }
public ActionResult ViewShulExpenses() { var fr = new FinancialRepository(Settings.Default.ConStr); IEnumerable <Expense> expenses = fr.GetExpensesWithPaps(); IEnumerable <ExpensePlus> expensesPlus = expenses.Select(e => new ExpensePlus { Id = e.Id, Name = e.Name, Cost = e.Cost, TotalDonations = e.Payments.Sum(p => p.Amount), TotalPledges = e.Pledges.Sum(p => p.Amount), Date = e.Date }); return(View(expensesPlus)); }
private void SendEmail(Member m, Response r, int expenseId, int amount) { FinancialRepository fr = new FinancialRepository(Settings.Default.ConStr); Expense expense = fr.GetExpenseByExpenseId(expenseId); var fromAddress = new MailAddress("*****@*****.**", "Beis Medrash of Jackson"); var toAddress = new MailAddress(m.Email, m.FirstName + " " + m.LastName); string fromPassword = "******"; string subject = "Your Donation"; string body = $"Hi {m.FirstName},\n\n"; if (r.Status == "Approved") { body += $"Thank you for your payment of ${amount}.00 towards {expense.Name}.\n"; } else if (r.Status == "Error") { body += $"There was an error with your payment of ${amount}.00 towards {expense.Name}.\n{r.Error}\n"; } else if (r.Status == "Declined") { body += $"Your payment of ${amount}.00 towards {expense.Name} has been declined.\n{r.Error}\n"; } body += $"Reference Number: {r.RefNum}"; var smtp = new SmtpClient { Host = "smtp.gmail.com", Port = 587, EnableSsl = true, DeliveryMethod = SmtpDeliveryMethod.Network, UseDefaultCredentials = false, Credentials = new NetworkCredential(fromAddress.Address, fromPassword) }; using (var message = new MailMessage(fromAddress, toAddress) { Subject = subject, Body = body }) { smtp.Send(message); } }
public ActionResult ViewMyActivity() { var repo = new VerifyRepository(Settings.Default.ConStr); Member member = repo.GetByEmail(User.Identity.Name); if (member == null) { return(RedirectToAction("ViewExpenses")); } var fr = new FinancialRepository(Settings.Default.ConStr); IEnumerable <Payment> payments = fr.GetPaymentsByMemberId(member.Id); IEnumerable <Pledge> pledges = fr.GetPledgesByMemberId(member.Id); IEnumerable <MonthlyPayment> monthlyPayments = fr.GetMonthlyPaymentsByMemberId(member.Id); IEnumerable <PaymentWithName> pwn = payments.Select(p => new PaymentWithName { Amount = p.Amount, Date = p.Date, Name = p.Expense.Name }); IEnumerable <PledgeWithName> plwn = pledges.Select(p => new PledgeWithName { Id = p.Id, Amount = p.Amount, Date = p.Date, Name = p.Expense.Name }); IEnumerable <MonthlyPaymentWithName> mpwn = monthlyPayments.Select(mp => new MonthlyPaymentWithName { Amount = mp.Amount, Name = mp.Expense.Name, Count = mp.Count.Value }); PaymentsAndPledges paps = new PaymentsAndPledges { Payments = pwn, Pledges = plwn, MonthlyPayments = mpwn }; return(View(paps)); }
public ActionResult GetById(int id) { FinancialRepository fr = new FinancialRepository(Settings.Default.ConStr); IEnumerable <Payment> payments = fr.GetPaymentsByMemberId(id); IEnumerable <Pledge> pledges = fr.GetPledgesByMemberId(id); IEnumerable <MonthlyPayment> monthlyPayments = fr.GetMonthlyPaymentsByMemberId(id); Member m = fr.GetMember(id); IEnumerable <PaymentWithName> pwn = payments.Select(p => new PaymentWithName { Amount = p.Amount, Date = p.Date, Name = p.Expense.Name }); IEnumerable <PledgeWithName> plwn = pledges.Select(p => new PledgeWithName { Id = p.Id, Amount = p.Amount, Date = p.Date, Name = p.Expense.Name }); IEnumerable <MonthlyPaymentWithName> mpwn = monthlyPayments.Select(mp => new MonthlyPaymentWithName { Amount = mp.Amount, Name = mp.Expense.Name, Count = mp.Count.Value }); PaymentsAndPledges paps = new PaymentsAndPledges { Payments = pwn, Pledges = plwn, MonthlyPayments = mpwn, Member = m }; return(View(paps)); }
public FinancialService() { repository = new(); }
public ActionResult Index(int amount, string name, string street, string zipcode, string exp, string xCardNum, string xCVV, int memberId, int expenseId, int?count, string account, string routing, bool credit) { if (amount == 0 || string.IsNullOrEmpty(name) || memberId == 0 || expenseId == 0 || amount > 1000000 || name.Length > 100) { return(RedirectToAction("Index", "Home")); } if (credit) { if (string.IsNullOrEmpty(street) || string.IsNullOrEmpty(zipcode) || string.IsNullOrEmpty(exp) || string.IsNullOrEmpty(xCardNum) || string.IsNullOrEmpty(xCVV) || street.Length > 250 || zipcode.Length > 9 || exp.Length > 4) { return(RedirectToAction("Index", "Home")); } } else { if (string.IsNullOrEmpty(account) || string.IsNullOrEmpty(routing)) { return(RedirectToAction("Index", "Home")); } } string command = credit ? "cc:Sale" : "check:Sale"; System.Collections.Specialized.NameValueCollection MyPost = new System.Collections.Specialized.NameValueCollection(); MyPost.Add("xKey", "YehoshuaLevinDev_Test_12301258f0bf44f2a6fcf0e"); MyPost.Add("xVersion", "4.5.5"); MyPost.Add("xSoftwareName", "ylevin"); MyPost.Add("xSoftwareVersion", " 1.4.2"); MyPost.Add("xCommand", command); MyPost.Add("xName", name); MyPost.Add("xAmount", amount.ToString()); if (credit) { MyPost.Add("xStreet", street); MyPost.Add("xZip", zipcode); MyPost.Add("xExp", exp); MyPost.Add("xCardNum", xCardNum); MyPost.Add("xCVV", xCVV); } else { MyPost.Add("xAccount", account); MyPost.Add("xRouting", routing); } System.Net.WebClient MyClient = new System.Net.WebClient(); string MyResponse = System.Text.Encoding.ASCII.GetString(MyClient.UploadValues("https://x1.cardknox.com/gateway", MyPost)); // Response System.Collections.Specialized.NameValueCollection MyResponseData = HttpUtility.ParseQueryString(MyResponse); string MyStatus = ""; if (MyResponseData.AllKeys.Contains("xStatus")) { MyStatus = MyResponseData["xStatus"]; } string MyError = ""; if (MyResponseData.AllKeys.Contains("xError")) { MyError = MyResponseData["xError"]; } string MyRefNum = ""; if (MyResponseData.AllKeys.Contains("xRefNum")) { MyRefNum = MyResponseData["xRefNum"]; } string MyToken = ""; if (MyResponseData.AllKeys.Contains("xToken")) { MyToken = MyResponseData["xToken"]; } Response response = new Response { Status = MyStatus, RefNum = MyRefNum, Error = MyError, }; FinancialRepository fr = new FinancialRepository(Settings.Default.ConStr); if (MyStatus == "Approved") { Payment p = new Payment { MemberId = memberId, ExpenseId = expenseId, Amount = amount, Date = DateTime.Today }; fr.AddPayment(p); } Member member = fr.GetMember(memberId); SendEmail(member, response, expenseId, amount); count--; if (MyStatus == "Approved" && count != null && credit) { MonthlyPayment mp = new MonthlyPayment { Amount = amount, Token = MyToken, Name = name, MemberId = memberId, ExpenseId = expenseId, Count = count.Value, Street = street, Zipcode = zipcode, Exp = exp, Credit = true }; fr.AddMonthlyPayment(mp); } else if (MyStatus == "Approved" && count != null && !credit) { MonthlyPayment mp = new MonthlyPayment { Amount = amount, Token = MyToken, Name = name, MemberId = memberId, ExpenseId = expenseId, Count = count.Value, Credit = false }; fr.AddMonthlyPayment(mp); } return(View(response)); }
public ActionResult MonthlyPayments(string password) { if (password != "hardpassword") { return(RedirectToAction("Index", "Home")); } FinancialRepository fr = new FinancialRepository(Settings.Default.ConStr); IEnumerable <MonthlyPayment> monthlyPayments = fr.GetMonthlyPayments(); List <Response> responses = new List <Response>(); foreach (MonthlyPayment mp in monthlyPayments) { string command = mp.Credit ? "cc:Sale" : "check:Sale"; System.Collections.Specialized.NameValueCollection MyPost = new System.Collections.Specialized.NameValueCollection(); MyPost.Add("xKey", "YehoshuaLevinDev_Test_12301258f0bf44f2a6fcf0e"); MyPost.Add("xVersion", "4.5.5"); MyPost.Add("xSoftwareName", "ylevin"); MyPost.Add("xSoftwareVersion", "1.4.2"); MyPost.Add("xCommand", "cc:Sale"); MyPost.Add("xAmount", mp.Amount.ToString()); MyPost.Add("xToken", mp.Token); MyPost.Add("xName", mp.Name); if (mp.Credit) { MyPost.Add("xStreet", mp.Street); MyPost.Add("xZip", mp.Zipcode); MyPost.Add("xExp", mp.Exp); } System.Net.WebClient MyClient = new System.Net.WebClient(); string MyResponse = System.Text.Encoding.ASCII.GetString(MyClient.UploadValues("https://x1.cardknox.com/gateway", MyPost)); // Response System.Collections.Specialized.NameValueCollection MyResponseData = HttpUtility.ParseQueryString(MyResponse); string MyStatus = ""; if (MyResponseData.AllKeys.Contains("xStatus")) { MyStatus = MyResponseData["xStatus"]; } string MyError = ""; if (MyResponseData.AllKeys.Contains("xError")) { MyError = MyResponseData["xError"]; } string MyRefNum = ""; if (MyResponseData.AllKeys.Contains("xRefNum")) { MyRefNum = MyResponseData["xRefNum"]; } Response response = new Response { Status = MyStatus, RefNum = MyRefNum, Error = MyError }; if (MyStatus == "Approved") { Payment p = new Payment { MemberId = mp.MemberId, ExpenseId = mp.ExpenseId, Amount = mp.Amount, Date = DateTime.Today }; fr.AddPayment(p); fr.UpdateMonthlyPayment(mp.Id); } Member member = fr.GetMember(mp.MemberId); SendEmail(member, response, mp.ExpenseId, mp.Amount); responses.Add(new Response { Status = MyStatus, RefNum = MyRefNum, Error = MyError }); } return(View(responses)); }