public BooleanInformationModel StoreResourceAllocationValues(DoubleIDModel d)
{
B = new BooleanInformationModel();
int Rcount = dbcontext.ResourceAllocations.Where(c => c.ResourceID == d.ID2).Count();
var Rresult = dbcontext.Resources.Any(c => c.ResourceID == d.ID2 && c.Threshold > Rcount);
if (Rresult == true)
{
ResourceAllocation value = new ResourceAllocation()
{
ProjectID = d.ID1, ResourceID = d.ID2
};
dbcontext.ResourceAllocations.Add(value);
dbcontext.SaveChanges();
int RAcount = dbcontext.ResourceAllocations.Where(c => c.ProjectID == d.ID1).Count();
Project Pr = dbcontext.Projects.Single(proj => proj.ProjectID == d.ID1);
Pr.NoOfResources = RAcount;
dbcontext.SaveChanges();
B.TrueOrFalse = true;
}
else
{
B.TrueOrFalse = false;
}
return(B);
}
private async void AddResAllocationBtn_ClickAsync(object sender, EventArgs e)
{
if (Validation_Check_For_Resource_Allocation() == true)
{
bool success = Int32.TryParse(SelectProCmbBox.SelectedValue.ToString(), out int id1);
bool success1 = Int32.TryParse(SelectResCmbBox.SelectedValue.ToString(), out int id2);
if (success && success1)
{
DoubleIDModel d = new DoubleIDModel {
ID1 = id1, ID2 = id2
};
BooleanInformationModel B = await RAB.StoreResourceAllocationAsync(d);
if (B.TrueOrFalse)
{
MessageBox.Show("ResourceAllocation is done");
}
else
{
MessageBox.Show("ResourceAllocation can't be done");
}
}
SelectProCmbBox_SelectedIndexChangedAsync(SelectProCmbBox.SelectedValue, null);
var projectNameOnly2 = await RAB.ShowProjectNameOnlyAsync();
this.ChoosePrjNameCmbBox.SelectedIndexChanged -= new System.EventHandler(this.ChoosePrjNameCmbBox_SelectedIndexChangedAsync);
ChoosePrjNameCmbBox.DataSource = projectNameOnly2;
ChoosePrjNameCmbBox.DisplayMember = "ProjectName";
ChoosePrjNameCmbBox.ValueMember = "ProjectID";
ChoosePrjNameCmbBox.SelectedIndex = -1;
this.ChoosePrjNameCmbBox.SelectedIndexChanged += new System.EventHandler(this.ChoosePrjNameCmbBox_SelectedIndexChangedAsync);
var project = await PB.ShowProjectDataAsync();
ProjectDataGrid.DataSource = project;
var projectNameOnly3 = await RAB.ShowResourceNameOnlyAsync();
this.ChooseResNameCmbBox.SelectedIndexChanged -= new System.EventHandler(this.ChooseResNameCmbBox_SelectedIndexChangedAsync);
ChooseResNameCmbBox.DataSource = projectNameOnly3;
ChooseResNameCmbBox.DisplayMember = "Name";
ChooseResNameCmbBox.ValueMember = "ResourceID";
ChooseResNameCmbBox.SelectedIndex = -1;
this.ChooseResNameCmbBox.SelectedIndexChanged += new System.EventHandler(this.ChooseResNameCmbBox_SelectedIndexChangedAsync);
this.ResourceDataGrid.DataSource = null;
//ResourceDataGrid.Rows.Clear();
ResourceDataGrid.Refresh();
ProjectDataGrid.DataSource = null;
ProjectDataGrid.Rows.Clear();
ProjectDataGrid.Refresh();
}
}
public BooleanInformationModel StoreResourceValues(ResourceModel obj)
{
Resource value = new Resource()
{
Name = obj.Name, Email = obj.Email, Threshold = obj.Threshold
};
dbcontext.Resources.Add(value);
dbcontext.SaveChanges();
B = new BooleanInformationModel()
{
TrueOrFalse = true
};
return(B);
}
public BooleanInformationModel StoreProjectValues(ProjectModel project)
{
Project value = new Project()
{
ProjectName = project.ProjectName, NoOfResources = project.NoOfResources
};
dbcontext.Projects.Add(value);
dbcontext.SaveChanges();
B = new BooleanInformationModel()
{
TrueOrFalse = true
};
return(B);
}
private async void SaveProEntryBtn_ClickAsync(object sender, EventArgs e)
{
if (Validation_Check_For_Project() == true)
{
PF = new ProjectModel()
{
ProjectName = NameProEntryTxtBox.Text, NoOfResources = 0
};
B = await PB.SaveProjectValues(PF);
if (B.TrueOrFalse)
{
MessageBox.Show("Value Stored Successfully");
}
this.DialogResult = DialogResult.OK;
}
}
private async void SaveResEntryBtn_ClickAsync(object sender, EventArgs e)
{
if (Validation_Check_For_Resource() == true)
{
RM = new ResourceModel()
{
Name = NameResEntryTxtBox.Text, Email = EmailResEntryTxtBox.Text, Threshold = Int32.Parse(ThresholdResEntryTxtBox.Text)
};
B = await RB.SaveResourceValues(RM);
if (B.TrueOrFalse)
{
MessageBox.Show("Value Stored Successfully");
}
this.DialogResult = DialogResult.OK;
}
}
