private void btn_Editroup_Save_Click(object sender, EventArgs e)
{
string GroupName = txt_EditGroup_GroupName.Text.ToString();
string GroupNumber = txt_EditGroup_GroupNo.Text.ToString();
int NoOfMember = int.Parse(txt_EditGroup_NumberOfMember.Text);
string ProjectTitle = txt_EditGroup_ProjectTitle.Text.ToString();
string semester = cmb_EditGroup_SemesterChooser.Text.ToString();
string subject = temporaryCourse;
string username = temporaryUser;
db_accountDataContext db1 = new db_accountDataContext();
tb_group acc1 = db1.tb_groups.SingleOrDefault(x => x.grp_groupNumber == GroupNumber);
acc1.grp_groupName = GroupName;
acc1.grp_projectTitle = ProjectTitle;
acc1.grp_NumberOfMember = NoOfMember;
acc1.grp_semester = semester;
acc1.grp_subject = subject;
acc1.grp_userName = username;
// db1.tb_groups.InsertOnSubmit(acc1);
db1.SubmitChanges();
foreach (string[] V1 in DataClass.EDitGroupTemporaryList)
{
string ax = V1[0];
string bx = V1[1];
string cx = V1[2];
string dx = V1[3];
// MessageBox.Show(V1[1]);
db_accountDataContext db = new db_accountDataContext();
tb_groupMember acc = db.tb_groupMembers.SingleOrDefault(x => x.grpm_stdId == bx);
acc.grpm_stdName = ax;
acc.grpm_section = cx;
acc.grpm_stdPart = dx;
acc.grpm_stdMark = 0;
acc.grpm_groupNumber = GroupNumber;
acc.grpm_subject = subject;
acc.grpm_semester = semester;
acc.grpm_username = username;
//db.tb_groupMembers.InsertOnSubmit(acc);
db.SubmitChanges();
MessageBox.Show("Success");
}
}
partial void Deletetb_groupMember(tb_groupMember instance);
partial void Updatetb_groupMember(tb_groupMember instance);
partial void Inserttb_groupMember(tb_groupMember instance);
private void btn_SaveGroup_Click(object sender, EventArgs e)
{
if ((txt_CreateGroup_NumberOfMember.Text != "") && (txt_CreateGroup_GroupName.Text != "") && (txt_CreateGroup_GroupNumber.Text != "") && (txt_CreateGroup_ProjectTitle.Text != "") && (cmb_CreateGroup_SemesterChooser.Text != " Semester"))
{
string GroupName = txt_CreateGroup_GroupName.Text.ToString();
string GroupNumber = txt_CreateGroup_GroupNumber.Text.ToString();
int NoOfMember = int.Parse(txt_CreateGroup_NumberOfMember.Text);
string ProjectTitle = txt_CreateGroup_ProjectTitle.Text.ToString();
string semester = cmb_CreateGroup_SemesterChooser.Text.ToString();
string subject = temporaryCourse;
string username = temporaryUser;
if ((NoOfMember >= 1) && (NoOfMember <= 4))
{
using (SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-UH9DSCF\SQLEXPRESS;Initial Catalog=Database;Integrated Security=True"))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = @"INSERT INTO [tb_group] ([grp_groupNumber], [grp_groupName],[grp_projecttitle],[grp_NumberOfMember],[grp_semester],[grp_subject],[grp_userName]) VALUES ( @number, @name,@title,@member,@sem,@sub,@user)";
command.Parameters.Add("@number", SqlDbType.VarChar, 150).Value = GroupNumber;
command.Parameters.Add("@name", SqlDbType.VarChar, 150).Value = GroupName;
command.Parameters.Add("@title", SqlDbType.VarChar, 150).Value = ProjectTitle;
command.Parameters.Add("@member", SqlDbType.Int).Value = NoOfMember;
command.Parameters.Add("@sem", SqlDbType.VarChar, 150).Value = semester;
command.Parameters.Add("@sub", SqlDbType.VarChar, 150).Value = subject;
command.Parameters.Add("@user", SqlDbType.VarChar, 150).Value = username;
connection.Open();
command.ExecuteNonQuery();
}
/* db_accountDataContext db1 = new db_accountDataContext();
* tb_group acc1 = new tb_group();
* acc1.grp_groupNumber = GroupNumber;
* acc1.grp_groupName = GroupName;
* acc1.grp_projectTitle = ProjectTitle;
* acc1.grp_NumberOfMember = NoOfMember;
* acc1.grp_semester = semester;
* acc1.grp_subject = subject;
* acc1.grp_userName = username;
* db1.tb_groups.InsertOnSubmit(acc1);
* db1.SubmitChanges();*/
int mark = 0;
foreach (string[] V1 in DataClass.CreateGroupTemporary)
{
string ax = V1[0];
string bx = V1[1];
string cx = V1[2];
string dx = V1[3];
// MessageBox.Show(V1[1]);
using (SqlConnection connection = new SqlConnection(@"Data Source=DESKTOP-UH9DSCF\SQLEXPRESS;Initial Catalog=Database;Integrated Security=True"))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandType = System.Data.CommandType.Text;
command.CommandText = @"INSERT INTO [tb_groupMember] ([grpm_stdName], [grpm_stdId],[grpm_section],[grpm_stdPart],[grpm_stdMark],[grpm_groupNumber],[grpm_subject],[grpm_semester]) VALUES (@a,@b,@c,@d,@e,@f,@g,@h)";
command.Parameters.Add("@a", SqlDbType.VarChar, 150).Value = ax;
command.Parameters.Add("@b", SqlDbType.VarChar, 150).Value = bx;
command.Parameters.Add("@c", SqlDbType.VarChar, 150).Value = cx;
command.Parameters.Add("@d", SqlDbType.VarChar, 150).Value = dx;
command.Parameters.Add("@e", SqlDbType.Int).Value = mark;
command.Parameters.Add("@f", SqlDbType.VarChar, 150).Value = GroupNumber;
command.Parameters.Add("@g", SqlDbType.VarChar, 150).Value = subject;
command.Parameters.Add("@h", SqlDbType.VarChar, 150).Value = semester;
connection.Open();
command.ExecuteNonQuery();
}
db_accountDataContext db = new db_accountDataContext();
tb_groupMember acc = new tb_groupMember();
acc.grpm_stdName = ax;
acc.grpm_stdId = bx;
acc.grpm_section = cx;
acc.grpm_stdPart = dx;
acc.grpm_stdMark = 0;
acc.grpm_groupNumber = GroupNumber;
acc.grpm_subject = subject;
acc.grpm_semester = semester;
acc.grpm_username = username;
db.tb_groupMembers.InsertOnSubmit(acc);
db.SubmitChanges();
}
MessageBox.Show("Group Created Successfully");
DataClass.CreateGroupAddStudent.Clear();
DataClass.CreateGroupTemporary.Clear();
fl_CreateGroup.Controls.Clear();
txt_CreateGroup_NumberOfMember.Text = "";
txt_CreateGroup_GroupName.Text = "";
txt_CreateGroup_GroupNumber.Text = "";
txt_CreateGroup_ProjectTitle.Text = "";
}
else
{
MessageBox.Show("Invalid Group Number. Group Member should be maximum 4");
}
}
else
{
MessageBox.Show("Please Fill all the required Fields");
}
}