private void button1_Click(object sender, EventArgs e)
{
using (var db = new Session1Entities())
{
var checkUser = from x in db.Users
where x.userId == tbUser.Text && x.userPw == tbPW.Text
select x;
if (checkUser.Count() != 1)
{
MessageBox.Show("Invalid Username or Password!");
}
else if (checkUser.First().userTypeIdFK != 1)
{
MessageBox.Show("This tool is only for resource managers.");
}
else
{
//login success
MessageBox.Show($"Welcome, {checkUser.First().userName}");
var nform = new formResourceManagement();
nform.Show();
this.Close();
}
}
}
private void btnBack_Click(object sender, EventArgs e)
{
var nform = new formResourceManagement();
nform.Show();
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
//add resource data checks
using (var db = new Session1Entities())
{
var itemlist = from x in db.Resources
select x.resName;
if (itemlist.Contains(tbResname.Text))
{
MessageBox.Show("Resource already exist");
}
else
{
var qcheck = int.TryParse(textBox1.Text, out int quantity);
if (!qcheck || quantity < 0)
{
MessageBox.Show("Invalid input for quantity");
}
else
{
if (quantity == 0 && checkedListBox1.CheckedItems.Count > 0)
{
MessageBox.Show("You cannot assign items without any quantity to skills");
}
else
{
var res = new Resource();
res.resName = tbResname.Text;
res.resTypeIdFK = comboBox1.SelectedIndex + 1;
res.remainingQuantity = quantity;
db.Resources.Add(res);
db.SaveChanges();
foreach (string skill in checkedListBox1.CheckedItems)
{
var skillid = (from x in db.Skills
where x.skillName == skill
select x.skillId).First();
var alloc = new Resource_Allocation();
alloc.resIdFK = res.resId;
alloc.skillIdFK = skillid;
db.Resource_Allocation.Add(alloc);
}
db.SaveChanges();
MessageBox.Show("add success");
var nform = new formResourceManagement();
nform.Show();
this.Close();
}
}
}
}
}
private void button1_Click(object sender, EventArgs e)
{
using (var db = new Session1Entities())
{
var qcheck = int.TryParse(tbQty.Text, out int quantity);
if (!qcheck || quantity < 0)
{
MessageBox.Show("Invalid input for quantity");
}
else
{
if (quantity == 0 && checkedListBox1.CheckedItems.Count > 0)
{
MessageBox.Show("You cannot assign items without any quantity to skills");
}
else
{
var res = (from x in db.Resources
where x.resId == resid
select x).First();
res.remainingQuantity = quantity;
var allocO = from x in db.Resource_Allocation
where x.resIdFK == resid
select x;
foreach (var a in allocO)
{
db.Resource_Allocation.Remove(a);
}
db.SaveChanges();
foreach (string skill in checkedListBox1.CheckedItems)
{
var skillid = (from x in db.Skills
where x.skillName == skill
select x.skillId).First();
var alloc = new Resource_Allocation();
alloc.resIdFK = res.resId;
alloc.skillIdFK = skillid;
db.Resource_Allocation.Add(alloc);
}
db.SaveChanges();
MessageBox.Show("update success");
var nform = new formResourceManagement();
nform.Show();
this.Close();
}
}
}
}