private void UpdateResource_Load(object sender, EventArgs e)
{
using (var context = new Session1Entities())
{
clbAllocatedSkills.Items.Clear();
var getSkills = (from x in context.Skills
select x.skillName).Distinct().ToArray();
clbAllocatedSkills.Items.AddRange(getSkills);
var getResource = (from x in context.Resources
where x.resId == _resourceID
select x).FirstOrDefault();
lblResourceName.Text = getResource.resName;
lblResourceType.Text = getResource.Resource_Type.resTypeName;
nudAvailableQuantity.Value = getResource.remainingQuantity;
var allocation = (from x in context.Resource_Allocation
where x.resIdFK == _resourceID
select x);
foreach (var skill in allocation)
{
_list.Add(skill.Skill.skillName);
}
CheckItems();
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
using (var context = new Session1Entities())
{
var getUser = (from x in context.Users
where x.userId == txtUserID.Text
select x).FirstOrDefault();
if (getUser == null)
{
MessageBox.Show("User does not exist!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (getUser.userPw != txtPassword.Text)
{
MessageBox.Show("Password is incorrect!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
if (getUser.userTypeIdFK == 1)
{
MessageBox.Show($"Welcome {getUser.userName}!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
(new ResourceManagement()).ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Sorry, your account is not permitted to use this application!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
using (var context = new Session1Entities())
{
var getAllocation = (from x in context.Resource_Allocation
where x.resIdFK == _resourceID
select x);
foreach (var item in getAllocation)
{
context.Resource_Allocation.Remove(item);
}
context.SaveChanges();
var getResource = (from x in context.Resources
where x.resId == _resourceID
select x).FirstOrDefault();
getResource.remainingQuantity = Convert.ToInt32(nudAvailableQuantity.Value);
context.SaveChanges();
foreach (var item in _list)
{
var getSkillID = (from x in context.Skills
where x.skillName == item
select x.skillId).FirstOrDefault();
context.Resource_Allocation.Add(new Resource_Allocation()
{
resIdFK = _resourceID, skillIdFK = getSkillID
});
}
context.SaveChanges();
MessageBox.Show("Updated resource successfully!", "Update Resource", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Hide();
(new ResourceManagement()).ShowDialog();
this.Close();
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow == null)
{
MessageBox.Show("Please select a resource to delete!", "Delete Resource", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var response = MessageBox.Show("Are you sure you want to delete this resource?", "Delete Resource", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (response == DialogResult.Yes)
{
var resourceID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
using (var context = new Session1Entities())
{
var allocation = (from x in context.Resource_Allocation
where x.resIdFK == resourceID
select x);
foreach (var item in allocation)
{
context.Resource_Allocation.Remove(item);
}
context.SaveChanges();
var resourceDelete = (from x in context.Resources
where x.resId == resourceID
select x).FirstOrDefault();
context.Resources.Remove(resourceDelete);
context.SaveChanges();
}
MessageBox.Show("Resource deleted successfully!", "Delete Resource", MessageBoxButtons.OK, MessageBoxIcon.Information);
dataGridView1.Rows.RemoveAt(dataGridView1.CurrentRow.Index);
}
}
}
private void RMAccountCreation_Load(object sender, EventArgs e)
{
using (var context = new Session1Entities())
{
var getUserTypes = (from x in context.User_Type
select x.userTypeName).Distinct().ToArray();
cbUserType.Items.AddRange(getUserTypes);
}
}
private void AddNewResource_Load(object sender, EventArgs e)
{
using (var context = new Session1Entities())
{
cbResourceType.Items.Clear();
clbAllocatedSkills.Items.Clear();
var getResourceTypes = (from x in context.Resource_Type
select x.resTypeName).Distinct().ToArray();
cbResourceType.Items.AddRange(getResourceTypes);
var getSkills = (from x in context.Skills
select x.skillName).Distinct().ToArray();
clbAllocatedSkills.Items.AddRange(getSkills);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
using (var context = new Session1Entities())
{
var checkResource = (from x in context.Resources
where x.resName == txtResourceName.Text
select x).FirstOrDefault();
if (checkResource != null)
{
}
else if (cbResourceType.SelectedItem == null)
{
}
else
{
var getResourceTypeID = (from x in context.Resource_Type
where x.resTypeName == cbResourceType.SelectedItem.ToString()
select x.resTypeId).FirstOrDefault();
context.Resources.Add(new Resource()
{
resName = txtResourceName.Text,
remainingQuantity = Convert.ToInt32(nudAvailableQuantity.Value),
resTypeIdFK = getResourceTypeID
});
context.SaveChanges();
var getNewID = (from x in context.Resources
where x.resName == txtResourceName.Text
select x.resId).FirstOrDefault();
foreach (var item in _list)
{
var getSkillID = (from x in context.Skills
where x.skillName == item
select x.skillId).FirstOrDefault();
context.Resource_Allocation.Add(new Resource_Allocation()
{
resIdFK = getNewID, skillIdFK = getSkillID
});
}
context.SaveChanges();
MessageBox.Show("Successfully added new resource!", "Add Resource", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtResourceName.Text = string.Empty;
nudAvailableQuantity.Value = 0;
AddNewResource_Load(null, null);
}
}
}
private void ResourceManagement_Load(object sender, EventArgs e)
{
cbSkill.Items.Clear();
cbType.Items.Clear();
cbSkill.Items.Add("All");
cbType.Items.Add("All");
using (var context = new Session1Entities())
{
var getTypes = (from x in context.Resource_Type
select x.resTypeName).Distinct().ToArray();
cbType.Items.AddRange(getTypes);
var getSkills = (from x in context.Skills
select x.skillName).Distinct().ToArray();
cbSkill.Items.AddRange(getSkills);
}
LoadDGV();
}
private void btnCreate_Click(object sender, EventArgs e)
{
using (var context = new Session1Entities())
{
var checkUserID = (from x in context.Users
where x.userId == txtUserID.Text
select x).FirstOrDefault();
if (txtUserID.TextLength < 8)
{
MessageBox.Show("User ID must be 8 characters long or more!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (cbUserType.SelectedItem == null)
{
MessageBox.Show("Please select User Type!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (checkUserID != null)
{
MessageBox.Show("User ID has been taken!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (txtPassword.Text != txtReEnterPassword.Text)
{
MessageBox.Show("Passwords do not match! Please check your passwords again!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var getUserTypeID = (from x in context.User_Type
where x.userTypeName == cbUserType.SelectedItem.ToString()
select x.userTypeId).FirstOrDefault();
context.Users.Add(new User()
{
userId = txtUserID.Text,
userName = txtUserName.Text,
userPw = txtReEnterPassword.Text,
userTypeIdFK = getUserTypeID
});
context.SaveChanges();
MessageBox.Show("Account created successfully!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
}
}
private void LoadDGV()
{
dataGridView1.Rows.Clear();
using (var context = new Session1Entities())
{
if ((cbSkill.SelectedItem == null || cbSkill.SelectedItem.ToString() == "All") && (cbType.SelectedItem == null || cbType.SelectedItem.ToString() == "All"))
{
var getResources = (from x in context.Resources
orderby x.remainingQuantity descending
select x);
foreach (var Resources in getResources)
{
var newRow = new List <string>()
{
Resources.resId.ToString(), Resources.resName, Resources.Resource_Type.resTypeName,
context.Resource_Allocation.Where(x => x.resIdFK == Resources.resId).Select(x => x).Count().ToString()
};
var getAllocation = (from x in context.Resource_Allocation
where x.resIdFK == Resources.resId
select x);
string allocationString = "Nil";
foreach (var skill in getAllocation)
{
if (allocationString == "Nil")
{
allocationString = skill.Skill.skillName;
}
else
{
allocationString += $", {skill.Skill.skillName}";
}
}
newRow.Add(allocationString);
if (Resources.remainingQuantity > 5)
{
newRow.Add("Sufficient");
}
else if (Resources.remainingQuantity <= 5 && Resources.remainingQuantity >= 1)
{
newRow.Add("Low Stock");
}
else
{
newRow.Add("Not Available");
}
dataGridView1.Rows.Add(newRow.ToArray());
}
}
else
{
if ((cbType.SelectedItem == null || cbType.SelectedItem.ToString() == "All") && cbSkill.SelectedItem.ToString() != "All")
{
var getResources = (from x in context.Resources
orderby x.remainingQuantity descending
select x);
foreach (var Resources in getResources)
{
var getAllocationCheck = (from x in context.Resource_Allocation
where x.resIdFK == Resources.resId && x.Skill.skillName.Contains(cbSkill.SelectedItem.ToString())
select x).FirstOrDefault();
if (getAllocationCheck == null)
{
continue;
}
else
{
var newRow = new List <string>()
{
Resources.resId.ToString(), Resources.resName, Resources.Resource_Type.resTypeName,
context.Resource_Allocation.Where(x => x.resIdFK == Resources.resId).Select(x => x).Count().ToString()
};
var getAllocation = (from x in context.Resource_Allocation
where x.resIdFK == Resources.resId
select x);
string allocationString = "Nil";
foreach (var skill in getAllocation)
{
if (allocationString == "Nil")
{
allocationString = skill.Skill.skillName;
}
else
{
allocationString += $", {skill.Skill.skillName}";
}
}
newRow.Add(allocationString);
if (Resources.remainingQuantity > 5)
{
newRow.Add("Sufficient");
}
else if (Resources.remainingQuantity <= 5 && Resources.remainingQuantity >= 1)
{
newRow.Add("Low Stock");
}
else
{
newRow.Add("Not Available");
}
dataGridView1.Rows.Add(newRow.ToArray());
}
}
}
else if ((cbSkill.SelectedItem == null || cbSkill.SelectedItem.ToString() == "All") && cbType.SelectedItem.ToString() != "All")
{
var getResources = (from x in context.Resources
where x.Resource_Type.resTypeName == cbType.SelectedItem.ToString()
orderby x.remainingQuantity descending
select x);
foreach (var Resources in getResources)
{
var newRow = new List <string>()
{
Resources.resId.ToString(), Resources.resName, Resources.Resource_Type.resTypeName,
context.Resource_Allocation.Where(x => x.resIdFK == Resources.resId).Select(x => x).Count().ToString()
};
var getAllocation = (from x in context.Resource_Allocation
where x.resIdFK == Resources.resId
select x);
string allocationString = "Nil";
foreach (var skill in getAllocation)
{
if (allocationString == "Nil")
{
allocationString = skill.Skill.skillName;
}
else
{
allocationString += $", {skill.Skill.skillName}";
}
}
newRow.Add(allocationString);
if (Resources.remainingQuantity > 5)
{
newRow.Add("Sufficient");
}
else if (Resources.remainingQuantity <= 5 && Resources.remainingQuantity >= 1)
{
newRow.Add("Low Stock");
}
else
{
newRow.Add("Not Available");
}
dataGridView1.Rows.Add(newRow.ToArray());
}
}
else if (cbSkill.SelectedItem.ToString() != "All" && cbType.SelectedItem.ToString() != "All")
{
var getResources = (from x in context.Resources
where x.Resource_Type.resTypeName == cbType.SelectedItem.ToString()
orderby x.remainingQuantity descending
select x);
foreach (var Resources in getResources)
{
var getAllocationCheck = (from x in context.Resource_Allocation
where x.resIdFK == Resources.resId && x.Skill.skillName.Contains(cbSkill.SelectedItem.ToString())
select x).FirstOrDefault();
if (getAllocationCheck == null)
{
continue;
}
else
{
var newRow = new List <string>()
{
Resources.resId.ToString(), Resources.resName, Resources.Resource_Type.resTypeName,
context.Resource_Allocation.Where(x => x.resIdFK == Resources.resId).Select(x => x).Count().ToString()
};
var getAllocation = (from x in context.Resource_Allocation
where x.resIdFK == Resources.resId
select x);
string allocationString = "Nil";
foreach (var skill in getAllocation)
{
if (allocationString == "Nil")
{
allocationString = skill.Skill.skillName;
}
else
{
allocationString += $", {skill.Skill.skillName}";
}
}
newRow.Add(allocationString);
if (Resources.remainingQuantity > 5)
{
newRow.Add("Sufficient");
}
else if (Resources.remainingQuantity <= 5 && Resources.remainingQuantity >= 1)
{
newRow.Add("Low Stock");
}
else
{
newRow.Add("Not Available");
}
dataGridView1.Rows.Add(newRow.ToArray());
}
}
}
}
foreach (DataGridViewRow row in dataGridView1.Rows)
{
if (dataGridView1.Rows[row.Index].Cells[5].Value.ToString() == "Not Available")
{
dataGridView1.Rows[row.Index].DefaultCellStyle.BackColor = Color.Red;
}
}
}
}