public bool AddIncome() { using (_context = new DigitalPocketContext()) { var obj = _context.UWallet.FirstOrDefault(x => x.UserId == id); obj.Ammount += Convert.ToDecimal(textBox2.Text); Transaction tr = new Transaction() { Ammount = Convert.ToDecimal(textBox2.Text), Category = comboBox1.Text, DateTime = Datetoenter, Note = richTextBox1.Text, OriginAccount = comboBox2.Text, UserId = id,//pass user id TransactionName = textBox1.Text, Type = type1 }; _context.Transaction.Add(tr); _context.SaveChanges(); TransacModel.Ammount = tr.Ammount.Value; TransacModel.TransactionName = tr.TransactionName; TransacModel.Category = tr.Category; TransacModel.Type = tr.Type; TransacModel.Allow = true; TransacModel.Type = type1; return(true); } }
private void LoadAppointments() { using (_context = new DigitalPocketContext()) { var obj = _context.Transaction.Where(x => x.UserId == id).ToList().Where(x => x.DateTime.Value.Month == DateTime.Now.Month && x.DateTime.Value.Year == DateTime.Now.Year); foreach (var items in obj) { if (items.Type == "Expense") { AddAppointment(items.TransactionName + " Ammount:" + items.Ammount, items.DateTime.Value.Date, items.DateTime.Value.Date, Appointment.CategoryRed, "", items.TransactionName + " Ammount:" + items.Ammount, items.TransactionName + " Ammount:" + items.Ammount); } if (items.Type == "Transfer") { AddAppointment(items.TransactionName + " Ammount:" + items.Ammount, items.DateTime.Value.Date, items.DateTime.Value.Date, Appointment.CategoryYellow, "", items.TransactionName + " Ammount:" + items.Ammount, items.TransactionName + " Ammount:" + items.Ammount); } if (items.Type == "Income") { AddAppointment(items.TransactionName + " Ammount:" + items.Ammount, items.DateTime.Value.Date, items.DateTime.Value.Date, Appointment.CategoryBlue, "", items.TransactionName + " Ammount:" + items.Ammount, items.TransactionName + " Ammount:" + items.Ammount); } } } }
public void getexpenseandincome(DateTime startDate1) { using (_context = new DigitalPocketContext()) { lbldate.Text = startDate1.Date.ToString("dd-MMM-yyyy"); var obj = _context.Transaction.ToList(); var income = obj.Where(x => x.UserId == id).Where(x => x.DateTime.Value.Date.Day == startDate1.Date.Day).Where(x => x.Type == "Income").Sum(x => x.Ammount); var Expense = obj.Where(x => x.UserId == id).Where(x => x.DateTime.Value.Date.Day == startDate1.Date.Day).Where(x => x.Type == "Expense").Sum(x => x.Ammount); var Transfer = obj.Where(x => x.UserId == id).Where(x => x.DateTime.Value.Date.Day == startDate1.Date.Day).Where(x => x.Type == "Transfer").Sum(x => x.Ammount); var MonthlyCredit = obj.Where(x => x.UserId == id).Where(x => x.DateTime.Value.Month == startDate1.Date.Month && x.DateTime.Value.Year == startDate1.Date.Year).Where(x => x.Type == "Income").Sum(x => x.Ammount); var MonthlyDebit = obj.Where(x => x.UserId == id).Where(x => x.DateTime.Value.Month == startDate1.Date.Month && x.DateTime.Value.Year == startDate1.Date.Year).Where(x => x.Type == "Expense").Sum(x => x.Ammount); var MonthlyTransefer = obj.Where(x => x.UserId == id).Where(x => x.DateTime.Value.Month == startDate1.Date.Month && x.DateTime.Value.Year == startDate1.Date.Year).Where(x => x.Type == "Transfer").Sum(x => x.Ammount); var monthlyincome = _context.UWallet.Where(x => x.UserId == id).ToList().Where(x => x.Date.Value.Month == DateTime.Now.Month).Sum(x => x.Ammount); if (monthlyincome <= 0) { lblincme.Text = monthlyincome.Value.ToString(); lblincme.ForeColor = Color.Red; } else { lblincme.Text = monthlyincome.ToString(); lblincme.ForeColor = Color.Black; } lblcredit.Text = MonthlyCredit.Value.ToString(); lblddebit.Text = MonthlyDebit.Value.ToString(); lblmonthlytrans.Text = MonthlyTransefer.Value.ToString(); lblincome.Text = income.Value.ToString(); lblexpense.Text = Expense.Value.ToString(); lblTransfer.Text = Transfer.Value.ToString(); } }
private void button1_Click(object sender, EventArgs e) { using (_context = new DigitalPocketContext()) { if (_context.PocketUser.Any(x => x.Username == textBox1.Text && x.Password == textBox2.Text)) { var obj = _context.PocketUser.FirstOrDefault(x => x.Username == textBox1.Text); Form1 form1 = new Form1(obj.Id, obj.Username); form1.Show(); this.Hide(); } else { MessageBox.Show("Incorrect UserName or Password"); } } }
private void button3_Click(object sender, EventArgs e) { using (_context = new DigitalPocketContext()) { if (_context.PocketUser.Any(x => x.Username == textBox1.Text)) { MessageBox.Show("User already exsist"); } else { if (String.IsNullOrEmpty(textBox1.Text) || String.IsNullOrEmpty(textBox2.Text) || String.IsNullOrEmpty(textBox3.Text) || String.IsNullOrEmpty(textBox4.Text)) { MessageBox.Show("One of the required field is missing"); } else { PocketUser pu = new PocketUser() { Email = textBox3.Text, Password = textBox2.Text, Username = textBox1.Text }; _context.PocketUser.Add(pu); _context.SaveChanges(); UWallet uw = new UWallet() { Ammount = Convert.ToDecimal(textBox4.Text), Date = DateTime.Now, UserId = pu.Id }; _context.UWallet.Add(uw); _context.SaveChanges(); MessageBox.Show("Account Created please login with your login details"); this.Close(); } } } }