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();
}
}
}
}
