public void LoadContacts()
{
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
this.contact = db.Contacts.ToList();
}
}
public void getUser(int id)
{
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
this.user = db.Users.First(u => u.Id == id);
}
}
private void Delete(object sender, EventArgs e)
{
if (MessageBox.Show("Are you sure to delete this record?", "Delete", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
;
}
{
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
cname.Text = contact.Name;
cemail.Text = contact.Emal;
ctype.Text = contact.Type;
}
}
}
private void Register(object sender, EventArgs e)
{
newuser.Name = name.Text.Trim();
newuser.Username = username.Text.Trim();
newuser.Email = email.Text.Trim();
newuser.Phone = phone.Text.Trim();
newuser.Password = MD5Encrypt(password.Text.Trim());
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
db.Users.Add(newuser);
db.SaveChanges();
}
Clear();
}
private void Save(object sender, EventArgs e)
{
contact = new Contact();
contact.Name = cname.Text.Trim();
contact.Emal = cemail.Text.Trim();
contact.Type = ctype.Text.Trim();
contact.UserId = this.id;
using (db = new FinanceManagementEntities())
{
db.Contacts.Add(contact);
db.SaveChanges();
}
populateContacts();
Clear();
}
public void populateContacts()
{
using (db = new FinanceManagementEntities())
{
var contact = from p in db.Contacts
select new
{
Id = p.Id,
Name = p.Name,
Type = p.Type,
Emal = p.Emal,
};
contactGridView.DataSource = contact.ToList();
contactGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
private void Update(object sender, EventArgs e)
{
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
contact = new Contact();
contact.UserId = 1;
contact.Id = SelectedId;
contact.Name = cname.Text;
contact.Emal = cemail.Text;
contact.Type = ctype.Text;
db.Entry(contact).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
this.Clear();
this.populateContacts();
}
public void populateAppointments()
{
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
var contact = from p in db.Events.OfType <Appointment>()
select new
{
Id = p.Id,
Name = p.Name,
Type = p.Type,
Datetime = p.Datetime
};
appointmentGridView.DataSource = contact.ToList();
appointmentGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
private void DoubleClickContact(object sender, EventArgs e)
{
if (contactGridView.CurrentRow.Index != -1)
{
contact = new Contact();
contact.Id = this.SelectedId = Int32.Parse(contactGridView.CurrentRow.Cells[0].Value.ToString());
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
contact = db.Contacts.Where(x => x.Id == contact.Id).FirstOrDefault();
cname.Text = contact.Name;
cemail.Text = contact.Emal;
ctype.Text = contact.Type;
}
btnupdate.Enabled = true;
btndelete.Enabled = true;
}
}
public void populateTasks()
{
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
var contact = from p in db.Events.OfType <Task>()
select new
{
Id = p.Id,
Name = p.Name,
Type = p.Type,
Datetime = p.Datetime,
Reccuring = p.Reccuring
};
taskGridView.DataSource = contact.ToList();
taskGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
}
private void TaskSave(object sender, EventArgs e)
{
tas = new Task();
tas.Name = taname.Text.Trim();
tas.Datetime = tadate.Text.Trim();
tas.Type = tatype.Text.Trim();
tas.Description = tadescription.Text.Trim();
tas.UserId = this.id;
tas.Reccuring = true;
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
db.Events.Add(tas);
db.SaveChanges();
}
ClearTask();
}
private void Login(object sender, EventArgs e)
{
if (username.ToString().Trim() != "" || password.ToString().Trim() != "")
{
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
User user = db.Users.SqlQuery("Select * from Users where Username=@username and Password=@password", new[] {
new SqlParameter("@username", username.Text.ToString().Trim()),
new SqlParameter("@password", MD5Encrypt(password.Text.ToString().Trim()))
}).FirstOrDefault();
if (user != null)
{
MainForm main = new MainForm(user.Name, user.Id);
this.Hide();
main.Show();
}
}
}
}
private void AppSave(object sender, EventArgs e)
{
//events = new Events();
app = new Appointment();
app.Name = apname.Text.Trim();
app.Datetime = apdate.Text.Trim();
app.Type = aptype.Text.Trim();
app.Description = apdescription.Text.Trim();
app.UserId = this.id;
app.User = this.user;
events = app;
using (FinanceManagementEntities db = new FinanceManagementEntities())
{
db.Events.Add(events);
db.SaveChanges();
}
ClearApp();
}
