private void btnLogin_Click(object sender, EventArgs e) { var userId = tbUserID.Text; var password = tbPassword.Text; //authentication using (var db = new Session1_WSOHEntities()) { var authentication = db.Users.Where(a => a.userId == userId).FirstOrDefault(); if (authentication != null) { if (authentication.userPw == password) { var resManagement = new ResourceManagement(); this.Hide(); resManagement.ShowDialog(); this.Show(); } else { MessageBox.Show("Incorrect Password"); } } else { MessageBox.Show("User does not exist"); } } }
private void btnUpdate_Click(object sender, EventArgs e) { using (var db = new Session1_WSOHEntities()) { var currentResource = db.Resources.Where(a => a.resId == resId).FirstOrDefault(); var qty = Convert.ToInt32(nudAvailableQty.Value); currentResource.remainingQuantity = qty; foreach (var skill in currentResource.Resource_Allocation.ToList()) { db.Resource_Allocation.Remove(skill); } foreach (var updatedSkill in clbAllocatedSkills.CheckedItems) { var skillId = db.Skills.Where(a => a.skillName == updatedSkill.ToString()).Select(a => a.skillId).FirstOrDefault(); var newAllocatedResources = new Resource_Allocation() { resIdFK = resId, skillIdFK = skillId }; db.Resource_Allocation.Add(newAllocatedResources); } try { db.SaveChanges(); MessageBox.Show("Changes have been successfully made to the resource"); this.Close(); } catch (Exception) { MessageBox.Show("Oops, something went wrong while saving your resource changes"); throw; } } }
private void EditResource_Load(object sender, EventArgs e) { loadAllocatedSkills(); using (var db = new Session1_WSOHEntities()) { var resource = db.Resources.Where(a => a.resId == resId).FirstOrDefault(); lblResourceName.Text = resource.resName.ToString(); lblResourceType.Text = resource.Resource_Type.resTypeName.ToString(); nudAvailableQty.Value = Convert.ToDecimal(resource.remainingQuantity); if (Convert.ToInt32(nudAvailableQty.Value) == 0) { clbAllocatedSkills.Visible = false; } else { foreach (var skills in resource.Resource_Allocation.ToList()) { var skillName = skills.Skill.skillName; for (var i = 0; i < clbAllocatedSkills.Items.Count; i++) { var cbSkillName = clbAllocatedSkills.Items[i].ToString(); if (cbSkillName == skillName) { clbAllocatedSkills.SetItemChecked(i, true); } } } } } }
private void btnAddresource_Click(object sender, EventArgs e) { var resourceName = tbResname.Text; var resourceType = ((Resource_Type)cbResType.SelectedItem).resTypeId; var availableQty = Convert.ToInt32(nudAvailableQty.Value); if (resourceName.Length == 0) { MessageBox.Show("Please enter a valid Resource name"); } else { using (var db = new Session1_WSOHEntities()) { //check if the resource exists first var checkResource = db.Resources.Where(a => a.resName == resourceName).FirstOrDefault(); if (checkResource != null) { MessageBox.Show("Sorry, this item exists in the records already"); } else { var newResource = new Resource() { resName = resourceName, resTypeIdFK = resourceType, remainingQuantity = availableQty }; db.Resources.Add(newResource); foreach (var selectedSkill in clbAllocatedSkills.CheckedItems) { var skillName = (string)selectedSkill; var skillid = db.Skills.Where(a => a.skillName == skillName).Select(a => a.skillId).FirstOrDefault(); var newResAloc = new Resource_Allocation() { resIdFK = newResource.resId, skillIdFK = skillid }; db.Resource_Allocation.Add(newResAloc); } try { db.SaveChanges(); MessageBox.Show("New Resource successfully created and saved to database"); tbResname.Clear(); nudAvailableQty.Value = 0; this.AddResource_Load(sender, e); } catch (Exception) { MessageBox.Show("Oops, an error occured"); throw; } } } } }
private void RMAccountCreation_Load(object sender, EventArgs e) { //getting user types using (var db = new Session1_WSOHEntities()) { var listUserTypes = db.User_Type.ToList(); cbUserType.DataSource = new BindingSource(listUserTypes, null); cbUserType.ValueMember = "userTypeId"; cbUserType.DisplayMember = "userTypeName"; } }
private void loadAllocatedSkills() { //Function to load allocated skills into list checkbox using (var db = new Session1_WSOHEntities()) { var listSkills = db.Skills.Select(a => a.skillName).ToList(); clbAllocatedSkills.Items.Clear(); foreach (var item in listSkills) { clbAllocatedSkills.Items.Add(item); } } }
private void AddResource_Load(object sender, EventArgs e) { using (var db = new Session1_WSOHEntities()) { var resTypes = db.Resource_Type.ToList(); cbResType.DataSource = new BindingSource(resTypes, null); cbResType.DisplayMember = "resTypeName"; cbResType.ValueMember = "resTypeId"; } if (Convert.ToInt32(nudAvailableQty.Value) == 0) { clbAllocatedSkills.Visible = false; } loadAllocatedSkills(); }
private void btnCreateAcct_Click(object sender, EventArgs e) { var selectedUserType = ((User_Type)cbUserType.SelectedItem).userTypeId; if (tbUsername.Text.Length != 0 || tbUserID.Text.Length != 0 || tbPassword.Text.Length != 0 || tbRtpassword.Text.Length != 0) { if (tbUserID.Text.Length < 8) { MessageBox.Show("User Id must be more than 8 characters in length"); } else { if (tbPassword.Text != tbRtpassword.Text) { MessageBox.Show("Mismatch Passwords"); } else { using (var db = new Session1_WSOHEntities()) { var checkUserId = db.Users.Where(a => a.userId == tbUserID.Text).FirstOrDefault(); if (checkUserId == null) { var newUser = new User() { userId = tbUserID.Text, userName = tbUsername.Text, userPw = tbPassword.Text, userTypeIdFK = selectedUserType }; db.Users.Add(newUser); db.SaveChanges(); this.Close(); } else { MessageBox.Show("Sorry, UserID has been taken"); } } } } } else { MessageBox.Show("Missing Fields"); } }
private void loadPickers() { using (var db = new Session1_WSOHEntities()) { var listResType = db.Resource_Type.ToList(); var listSkills = db.Skills.ToList(); resType.Add("Type"); skilllist.Add("Skill"); foreach (var item in listResType) { resType.Add(item.resTypeName); } foreach (var item in listSkills) { skilllist.Add(item.skillName); } cbType.DataSource = new BindingSource(resType, null); cbSkill.DataSource = new BindingSource(skilllist, null); } }
private void btnDelete_Click(object sender, EventArgs e) { var selectedResource = Convert.ToInt32(dgvResources.CurrentRow.Cells[5].Value); using (var db = new Session1_WSOHEntities()) { var resourceTBD = db.Resources.Where(a => a.resId == selectedResource).FirstOrDefault(); foreach (var r in resourceTBD.Resource_Allocation.ToList()) { db.Resource_Allocation.Remove(r); } db.Resources.Remove(resourceTBD); try { db.SaveChanges(); MessageBox.Show("Resource Successfully deleted"); this.ResourceManagement_Load(sender, e); } catch (Exception) { MessageBox.Show("Whoops! An error occured while deleting this resource"); } } }
private void cbType_SelectedIndexChanged(object sender, EventArgs e) { string availability = ""; var selectedType = (string)cbType.SelectedValue; var selectedSkill = (string)cbSkill.SelectedValue; if (selectedType == "Type") { if (selectedSkill == "Skill") { using (var db = new Session1_WSOHEntities()) { //get all resources var listResources = db.Resources.OrderByDescending(a => a.remainingQuantity).ToList(); dgvResources.Rows.Clear(); foreach (var res in listResources) { var allocatedSkills = string.Join(",", res.Resource_Allocation.Select(a => a.Skill.skillName).ToList()); if (res.remainingQuantity > 5) { availability = "Sufficient"; } else if (res.remainingQuantity >= 1 && res.remainingQuantity < 5) { availability = "Low Stock"; } else { availability = "Not Available"; } object[] row = new object[] { res.resName, res.Resource_Type.resTypeName, res.Resource_Allocation.Count(), allocatedSkills, availability, res.resId }; dgvResources.Rows.Add(row); } } } else { using (var db = new Session1_WSOHEntities()) { //get resources according to the selected skill var listResources = db.Resource_Allocation.OrderByDescending(a => a.Resource.remainingQuantity).Where(a => a.Skill.skillName == selectedSkill).ToList(); dgvResources.Rows.Clear(); foreach (var res in listResources) { var allocatedSkills = string.Join(",", res.Skill.skillName.ToList()); if (res.Resource.remainingQuantity > 5) { availability = "Sufficient"; } else if (res.Resource.remainingQuantity >= 1 && res.Resource.remainingQuantity < 5) { availability = "Low Stock"; } else { availability = "Not Available"; } object[] row = new object[] { res.Resource.resName, res.Resource.Resource_Type.resTypeName, res.Resource.Resource_Allocation.Count(), allocatedSkills, availability, res.resIdFK }; dgvResources.Rows.Add(row); } } } } else { if (selectedSkill == "Skill") { using (var db = new Session1_WSOHEntities()) { var listResources = db.Resources.Where(a => a.Resource_Type.resTypeName == selectedType).OrderByDescending(a => a.remainingQuantity).ToList(); dgvResources.Rows.Clear(); foreach (var res in listResources) { var allocatedSkills = string.Join(",", res.Resource_Allocation.Select(s => s.Skill.skillName).ToList()); if (res.remainingQuantity > 5) { availability = "Sufficient"; } else if (res.remainingQuantity >= 1 && res.remainingQuantity < 5) { availability = "Low Stock"; } else { availability = "Not Available"; } object[] row = new object[] { res.resName, res.Resource_Type.resTypeName, res.Resource_Allocation.Count(), allocatedSkills, availability, res.resId }; dgvResources.Rows.Add(row); } } } else { using (var db = new Session1_WSOHEntities()) { var listResources = db.Resource_Allocation.Where(a => a.Skill.skillName == selectedSkill && a.Resource.Resource_Type.resTypeName == selectedType).ToList(); dgvResources.Rows.Clear(); foreach (var res in listResources) { var allocatedSkills = string.Join(",", res.Resource.Resource_Allocation.Select(a => a.Skill.skillName).ToList()); if (res.Resource.remainingQuantity > 5) { availability = "Sufficient"; } else if (res.Resource.remainingQuantity >= 1 && res.Resource.remainingQuantity < 5) { availability = "Low Stock"; } else { availability = "Not Available"; } object[] row = new object[] { res.Resource.resName, res.Resource.Resource_Type.resTypeName, res.Resource.Resource_Allocation.Count(), allocatedSkills, availability, res.resIdFK }; dgvResources.Rows.Add(row); } } } } }