private void toolStripButtonSave_Click(object sender, EventArgs e)
{
try
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
tblHouse house = new tblHouse();
house.RegionID = int.Parse(cboRegion.SelectedValue.ToString());
house.SubCityID = int.Parse(cboSubCity.SelectedValue.ToString());
house.WoredaID = int.Parse(cboWoreda.SelectedValue.ToString());
house.BlockNumber = txtBlockNumber.Text;
house.FloorNumber = int.Parse(txtFloorNumber.Text);
house.HouseNumber = txtHouseNumber.Text;
house.GovernmentTransferedDate = dtpGovernmentTrasferedDate.Value;
house.SiteName = txtSiteName.Text;
entity.tblHouses.Add(house);
entity.SaveChanges();
MessageBox.Show("Saved");
}
catch (Exception)
{
MessageBox.Show("Save Failed");
}
}
private void toolStripButtonUpdate_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int houseId = int.Parse(listViewHouse.Items[listViewHouse.SelectedIndices[0]].SubItems[0].Text);
tblHouse oldHouse = entity.tblHouses.Where(x => x.ID == houseId).FirstOrDefault();
tblHouse newHouse = new tblHouse();
newHouse.ID = houseId;
newHouse.RegionID = int.Parse(cboRegion.SelectedValue.ToString());
newHouse.SubCityID = int.Parse(cboSubCity.SelectedValue.ToString());
newHouse.WoredaID = int.Parse(cboWoreda.SelectedValue.ToString());
newHouse.BlockNumber = txtBlockNumber.Text;
newHouse.FloorNumber = int.Parse(txtFloorNumber.Text);
newHouse.HouseNumber = txtHouseNumber.Text;
newHouse.GovernmentTransferedDate = dtpGovernmentTrasferedDate.Value;
newHouse.SiteName = txtSiteName.Text;
entity.Entry(oldHouse).CurrentValues.SetValues(newHouse);
entity.SaveChanges();
MessageBox.Show("Updated");
}
private void LoadRoleCombo()
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblRole> roles = entity.tblRoles.ToList();
cboRole.DataSource = roles;
cboRole.ValueMember = "ID";
cboRole.DisplayMember = "Title";
}
private void LoadWoredaCombo()
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblWoreda> woredas = entity.tblWoredas.ToList();
cboWoreda.DataSource = woredas;
cboWoreda.ValueMember = "ID";
cboWoreda.DisplayMember = "Title";
}
private void LoadUserCombo()
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblUser> users = entity.tblUsers.ToList();
cboUser.DataSource = users;
cboUser.ValueMember = "ID";
cboUser.DisplayMember = "Fullname";
}
private void LoadSubCityCombo()
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblSubCity> subcities = entity.tblSubCities.ToList();
cboSubCity.DataSource = subcities;
cboSubCity.ValueMember = "ID";
cboSubCity.DisplayMember = "Title";
}
private void LoadRegionCombo()
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblRegion> regions = entity.tblRegions.ToList();
cboRegion.DataSource = regions;
cboRegion.ValueMember = "ID";
cboRegion.DisplayMember = "Title";
}
private void toolStripButtonDelete_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int houseId = int.Parse(listViewHouse.Items[listViewHouse.SelectedIndices[0]].SubItems[0].Text);
tblHouse oldHouse = entity.tblHouses.Where(x => x.ID == houseId).FirstOrDefault();
entity.tblHouses.Remove(oldHouse);
entity.SaveChanges();
MessageBox.Show("Deleted");
}
private void btnDelete_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int userID = int.Parse(listViewUser.Items[listViewUser.SelectedIndices[0]].SubItems[0].Text);
tblUser oldUser = entity.tblUsers.Where(x => x.ID == userID).FirstOrDefault();
entity.tblUsers.Remove(oldUser);
entity.SaveChanges();
MessageBox.Show("User Deleted");
}
private void btnSave_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
tblRole role = new Condominium_Management_System.tblRole();
role.Title = txtTitle.Text;
entity.tblRoles.Add(role);
entity.SaveChanges();
MessageBox.Show("Role Saved");
}
private void btnSave_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
tblUserRole userRole = new Condominium_Management_System.tblUserRole();
userRole.UserID = int.Parse(cboUser.SelectedValue.ToString());
userRole.RoleID = int.Parse(cboRole.SelectedValue.ToString());
entity.tblUserRoles.Add(userRole);
entity.SaveChanges();
MessageBox.Show("User Role Saved");
}
private void frmRole_Load(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblRole> roles = entity.tblRoles.ToList();
foreach (tblRole role in roles)
{
ListViewItem item = new ListViewItem(role.ID.ToString());
item.SubItems.Add(role.Title);
listViewRole.Items.Add(item);
}
}
public bool IsInRole(string username, string role)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int count = entity.tblUserRoles.Where(x => x.tblUser.Username == username && x.tblRole.Title == role).Count();
if (count == 0)
{
return(false);
}
else
{
return(true);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
tblUser user = new Condominium_Management_System.tblUser();
user.Fullname = txtFullname.Text;
user.Username = txtUsername.Text;
user.Password = txtPassword.Text;
entity.tblUsers.Add(user);
entity.SaveChanges();
MessageBox.Show("User Saved");
}
private void frmUser_Load(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblUser> users = entity.tblUsers.ToList();
foreach (tblUser user in users)
{
ListViewItem item = new ListViewItem(user.ID.ToString());
item.SubItems.Add(user.Fullname);
item.SubItems.Add(user.Username);
item.SubItems.Add(user.Password);
listViewUser.Items.Add(item);
}
}
private void frmUserRole_Load(object sender, EventArgs e)
{
LoadUserCombo();
LoadRoleCombo();
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblUserRole> userRoles = entity.tblUserRoles.ToList();
foreach (tblUserRole userRole in userRoles)
{
ListViewItem item = new ListViewItem(userRole.ID.ToString());
item.SubItems.Add(userRole.tblUser.Fullname);
item.SubItems.Add(userRole.tblRole.Title);
listViewUserRole.Items.Add(item);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int roleID = int.Parse(listViewRole.Items[listViewRole.SelectedIndices[0]].SubItems[0].Text);
tblRole oldRole = entity.tblRoles.Where(x => x.ID == roleID).FirstOrDefault();
tblRole newRole = new Condominium_Management_System.tblRole();
newRole.ID = roleID;
newRole.Title = txtTitle.Text;
entity.Entry(oldRole).CurrentValues.SetValues(newRole);
entity.SaveChanges();
MessageBox.Show("Role Updated");
}
private void btnLogin_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
tblUser user = entity.tblUsers.Where(x => x.Username == txtUsername.Text && x.Password == txtPassword.Text).FirstOrDefault();
if (user != null)
{
frmHome frm = new Condominium_Management_System.frmHome();
frm.Tag = txtUsername.Text;
frm.ShowDialog();
this.Hide();
}
else
{
MessageBox.Show("Invalid username or password");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
int userID = int.Parse(listViewUser.Items[listViewUser.SelectedIndices[0]].SubItems[0].Text);
tblUser oldUser = entity.tblUsers.Where(x => x.ID == userID).FirstOrDefault();
tblUser newUser = new Condominium_Management_System.tblUser();
newUser.ID = userID;
newUser.Fullname = txtFullname.Text;
newUser.Username = txtUsername.Text;
newUser.Password = txtPassword.Text;
entity.Entry(oldUser).CurrentValues.SetValues(newUser);
entity.SaveChanges();
MessageBox.Show("User Updated");
}
private void listViewHouse_SelectedIndexChanged(object sender, EventArgs e)
{
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
if (listViewHouse.SelectedIndices.Count > 0)
{
int houseId = int.Parse(listViewHouse.Items[listViewHouse.SelectedIndices[0]].SubItems[0].Text);
tblHouse house = entity.tblHouses.Where(x => x.ID == houseId).FirstOrDefault();
cboRegion.Text = house.tblRegion.TItle;
cboSubCity.Text = house.tblSubCity.TItle;
cboWoreda.Text = house.tblWoreda.TItle;
txtBlockNumber.Text = house.BlockNumber;
txtFloorNumber.Text = house.FloorNumber.ToString();
txtHouseNumber.Text = house.HouseNumber;
dtpGovernmentTrasferedDate.Value = house.GovernmentTransferedDate;
txtSiteName.Text = house.SiteName;
}
}
private void frmHouse_Load(object sender, EventArgs e)
{
LoadRegionCombo();
LoadSubCityCombo();
LoadWoredaCombo();
CondominiumManagementSystemDBEntities entity = new Condominium_Management_System.CondominiumManagementSystemDBEntities();
List <tblHouse> houses = entity.tblHouses.ToList();
foreach (tblHouse house in houses)
{
ListViewItem item = new ListViewItem(house.ID.ToString());
item.SubItems.Add(house.tblWoreda.TItle);
item.SubItems.Add(house.BlockNumber);
item.SubItems.Add(house.FloorNumber.ToString());
item.SubItems.Add(house.HouseNumber);
item.SubItems.Add(house.GovernmentTransferedDate.ToString());
item.SubItems.Add(house.SiteName);
listViewHouse.Items.Add(item);
}
SecurityPolicy policy = new Condominium_Management_System.SecurityPolicy();
bool IsAllowed = policy.IsInRole(this.Tag.ToString(), "Office Clerk");
if (IsAllowed == true)
{
toolStripButtonNew.Enabled = true;
toolStripButtonSave.Enabled = true;
toolStripButtonUpdate.Enabled = true;
toolStripButtonDelete.Enabled = true;
}
else
{
toolStripButtonNew.Enabled = false;
toolStripButtonSave.Enabled = false;
toolStripButtonUpdate.Enabled = false;
toolStripButtonDelete.Enabled = false;
}
}
