public ProjectSelect(int GroupId, GroupDetails parent)
{
InitializeComponent();
this.MinimumSize = new Size(this.Width, this.Height);
id = GroupId;
par = parent;
Refresh();
}
public EvaluationSelect(int GroupId, GroupDetails parent)
{
InitializeComponent();
EDDatePicker.MaxDate = DateTime.Now;
EDDatePicker.Value = EDDatePicker.MaxDate;
this.MinimumSize = new Size(this.Width, this.Height);
id = GroupId;
par = parent;
OMError.Text = "";
Refresh();
}
private void SelectButton_Click(object sender, EventArgs e)
{
try
{
if (RegCombBox.Text == "\0")
{
MessageBox.Show("Box cannot be empty.");
return;
}
if (flag == 0)
{
String ids = "-1";
int GId = 0;
foreach (int x in SId)
{
ids = ids + ", " + x.ToString();
}
String cmd = "SELECT GroupId, StudentId FROM GroupStudent WHERE GroupId = (Select GroupId FROM GroupStudent JOIN Student ON StudentId = Id WHERE RegistrationNo = '" + RegCombBox.SelectedItem.ToString() + "' AND Status = (SELECT Id FROM Lookup WHERE Category = 'STATUS' AND Value = 'Active')) AND StudentID IN (" + ids + ")";
var reader = DatabaseConnection.getInstance().getData(cmd);
while (reader.Read())
{
SId.Remove((int)reader.GetValue(1));
GId = (int)reader.GetValue(0);
}
ids = "-1";
foreach (int x in SId)
{
ids = ids + ", " + x.ToString();
}
cmd = "UPDATE GroupStudent SET Status = (SELECT Id FROM Lookup WHERE Category = 'STATUS' AND Value = 'InActive') WHERE StudentId IN (Select Id from Student JOIN GroupStudent ON Id = StudentId WHERE Id IN (" + ids + "))";
DatabaseConnection.getInstance().exectuteQuery(cmd);
foreach (int x in SId)
{
cmd = String.Format("Insert INTO GroupStudent(GroupId, StudentId, Status, AssignmentDate) values('{0}', '{1}', (SELECT Id FROM Lookup WHERE Category = 'STATUS' AND Value = 'Active'), GETDATE())", GId, x);
DatabaseConnection.getInstance().exectuteQuery(cmd);
}
Parent.Refresh();
MessageBox.Show("Students added.");
this.Close();
}
else if (flag == 1)
{
int flag2 = 0;
String data = "";
foreach (char x in RegCombBox.SelectedItem.ToString())
{
if (flag2 <= 1 && x == ' ')
{
flag2++;
}
else if (x == '\0')
{
break;
}
else if (flag2 == 2)
{
data = data + x;
}
}
string cmd = "SELECT GroupProject.GroupId FROM (Student JOIN GroupStudent ON Student.Id = StudentId) JOIN GroupProject ON GroupStudent.GroupId = GroupProject.GroupId WHERE ProjectId = " + Id.ToString() + " AND RegistrationNo = '" + data + "' AND Status = (SELECT Id FROM Lookup WHERE Category = 'STATUS' AND Value = 'Active')";
var reader = DatabaseConnection.getInstance().getData(cmd);
while (reader.Read())
{
GroupDetails gd = new GroupDetails((int)reader.GetValue(0));
this.Close();
gd.Show();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}