private void errorReportToolStripMenuItem_Click(object sender, EventArgs e)
{
string[] filePaths = Directory.GetFiles("Logs");
FileInfo filename;
try
{
var desktopFolder = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory);
var fullFileName = Path.Combine(desktopFolder, "Logs");
if (!Directory.Exists(fullFileName))
{
Directory.CreateDirectory(fullFileName);
}
for (int i = 1; i < filePaths.Length; i++)
{
filename = new FileInfo(filePaths[i]);
File.Copy(filePaths[i], Path.Combine(fullFileName, filename.Name));
}
MessageBox.Show("File Export completed");
}
catch (Exception err)
{
MessageBox.Show("File or Directory Already Exists", "File Copy Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Export method of FormSelection:" + err.Message);
}
}
private void bAdd_Click(object sender, EventArgs e)
{
if (cid.Text == "" || cfname.Text == "" || clname.Text == "" || cemail.Text == "" || cnum.Text == "" || cpos.Text == "" || ccity.Text == "" || ccntry.Text == "" || cnpos.Text =="" || caddr.Text == "")
{
MessageBox.Show("Please fill in the required fields marked in red.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("insert into company(cpyname,spocfname,spoclname,position,number,email,fax,city,country,zipcode,address,jobsavail,jobresp,jobreq,jobdesc,cmpid) values(@name,@sf,@sl,@pos,@num,@mail,@fx,@cty,@ctry,@zcode,@addr,@tot,@resp,@req,@desc,@id)", con);
cmdnewdb.Parameters.AddWithValue("id", int.Parse(cid.Text));
cmdnewdb.Parameters.AddWithValue("name", cname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("sf", cfname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("sl", clname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("pos", cpos.Text.Trim());
cmdnewdb.Parameters.AddWithValue("num", cnum.Text);
cmdnewdb.Parameters.AddWithValue("mail", cemail.Text);
cmdnewdb.Parameters.AddWithValue("fx", cfax.Text.Trim());
cmdnewdb.Parameters.AddWithValue("cty", ccity.Text);
cmdnewdb.Parameters.AddWithValue("ctry", ccntry.Text);
cmdnewdb.Parameters.AddWithValue("zcode", cpostal.Text == "" ? 0 : int.Parse(cpostal.Text));
cmdnewdb.Parameters.AddWithValue("addr", caddr.Text.Trim());
cmdnewdb.Parameters.AddWithValue("tot", int.Parse(cnpos.Text));
cmdnewdb.Parameters.AddWithValue("resp", cresp.Text.Trim());
cmdnewdb.Parameters.AddWithValue("req", creq.Text.Trim());
cmdnewdb.Parameters.AddWithValue("desc", cdesc.Text.Trim());
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Company Details Added Succesfully", "Add Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
clearControls(sender, e);
}
catch (Exception err)
{
MessageBox.Show("Problem can be due to following reasons: \n\n1.Company ID already Exists\n2. Problem with Database Connection", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Add method of CompanyForm Page :" + err.Message);
}//End of Catch
finally
{
con.Close();
}
}//End of Outer If-Else
}
private void bDelete_Click(object sender, EventArgs e)
{
int status;
if (facid.Text == "")
{
MessageBox.Show("Please enter an Faculty ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
facid.Focus();
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("delete from faculty where facid=@fid", con);
cmdnewdb.Parameters.AddWithValue("fid", int.Parse(facid.Text.Trim()));
status = cmdnewdb.ExecuteNonQuery();
if(status > 0)
{
MessageBox.Show("Faculty Details Deleted Succesfully", "Update Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
}
else
{
MessageBox.Show("No Records Found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
facid.SelectAll();
facid.Focus();
dr.Close();
}
con.Close();
clearControls(sender, e);
}
catch (Exception err)
{
MessageBox.Show("Problem may be: Database Connection doe not exist. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Delete method of Faculty Page :" + err.Message);
}
}
}
private void bAdd_Click(object sender, EventArgs e)
{
if (studstat.Text == "" || tfname.Text == "" || tmname.Text == "" || size.Text == "" || pdesc.Text == "" || tcname.Text == "" || istatus.Text == "" || title.Text == "")
{
MessageBox.Show("Please fill in all the fields.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("insert into internship(studid,status,cname,mgrname,facname,title,size,istatus,pdesc) values(@sid,@st,@name,@mgr,@fac,@head,@tot,@istat,@desc)", con);
cmdnewdb.Parameters.AddWithValue("sid", sid);
cmdnewdb.Parameters.AddWithValue("st", studstat.SelectedItem.ToString());
cmdnewdb.Parameters.AddWithValue("name", tcname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("mgr", tmname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("fac", tfname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("head", title.Text.Trim());
cmdnewdb.Parameters.AddWithValue("tot",int.Parse(size.Text));
cmdnewdb.Parameters.AddWithValue("istat", istatus.SelectedItem.ToString());
cmdnewdb.Parameters.AddWithValue("desc", pdesc.Text.Trim());
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Student Internship Details Added Succesfully", "Add Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
con.Close();
this.Hide();
}
catch (Exception err)
{
MessageBox.Show("There is a problem with input values. Please provide valid inputs.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Add Student method of StudentInternship Page :" + err.Message);
}//End of Catch
}//End of Outer If-Else
}
private void bDelete_Click(object sender, EventArgs e)
{
int status;
if(sid.Text!="")
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("delete from education where studid=@id", con);
cmdnewdb.Parameters.AddWithValue("id", sid.Text.Trim());
status = cmdnewdb.ExecuteNonQuery();
if (status > 0)
{
MessageBox.Show("Student Education Details Deleted Succesfully", "Delete Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("No records found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cmdnewdb.Parameters.Clear();
con.Close();
}
catch (Exception err)
{
MessageBox.Show("Problem may be: Database Connection doe not exist or Invalid Student ID. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Delete method of Student Education Page :" + err.Message);
}
}
else
{
MessageBox.Show("Please enter a student ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
sid.SelectAll();
sid.Focus();
}
}
private void bSave_Click(object sender, EventArgs e)
{
if (facid.Text == "" || fname.Text == "" || lname.Text == "" || desig.Text == "" || mobile.Text == "" || email.Text == "" || dept.SelectedIndex == -1 || number.Text == "")
{
MessageBox.Show("Please fill in all the required fields marked in red.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (mobile.Text.Length < 10)
{
MessageBox.Show("Please enter 10-digit mobile number.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("select * from faculty where facid =@fid",con);
cmdnewdb.Parameters.AddWithValue("fid", int.Parse(facid.Text.Trim()));
dr = cmdnewdb.ExecuteReader();
dr.Read();
if (dr.HasRows) // if the id is already in database then return true
{
MessageBox.Show("Duplicate Faculty ID. Please give another ID.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
facid.SelectAll();
facid.Focus();
dr.Close();
}
else
{
dr.Close();
cmdnewdb = new MySqlCommand("insert into faculty(fname,lname,number,desig,dept,extn,mobile,email,notes,facid) values(@name1,@name2,@num,@des,@dpt,@ext,@mob,@mail,@note,@id)", con);
cmdnewdb.Parameters.AddWithValue("id", int.Parse(facid.Text.Trim()));
cmdnewdb.Parameters.AddWithValue("name1", fname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("name2", lname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("des", desig.Text.Trim());
cmdnewdb.Parameters.AddWithValue("dpt", dept.SelectedItem.ToString());
cmdnewdb.Parameters.AddWithValue("num", number.Text.Trim());
cmdnewdb.Parameters.AddWithValue("ext", extn.Text.Trim());
cmdnewdb.Parameters.AddWithValue("mob", mobile.Text);
cmdnewdb.Parameters.AddWithValue("mail", email.Text.Trim());
cmdnewdb.Parameters.AddWithValue("note", notes.Text.Trim());
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Faculty Details Added Succesfully", "Add Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
clearControls(sender, e);
}
con.Close();
}
catch (Exception err)
{
MessageBox.Show("There must be a Database Connection Problem. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Save method of Faculty Page :" + err.Message);
}//End of Catch
}//End of Outer If-Else
}
private void bUpdate_Click(object sender, EventArgs e)
{
if (facid.Text == "")
{
MessageBox.Show("Please enter an Faculty ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
facid.Focus();
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("select * from faculty where facid=@fid", con);
cmdnewdb.Parameters.AddWithValue("fid", int.Parse(facid.Text.Trim()));
dr = cmdnewdb.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
dr.Close();
cmdnewdb = new MySqlCommand("update faculty set fname=@name1,lname=@name2,number=@num,desig=@des,dept=@dpt,extn=@ext,mobile=@mob,email=@mail,notes=@note where facid=@id", con);
cmdnewdb.Parameters.AddWithValue("id", int.Parse(facid.Text.Trim()));
cmdnewdb.Parameters.AddWithValue("name1", fname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("name2", lname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("des", desig.Text.Trim());
cmdnewdb.Parameters.AddWithValue("dpt", dept.SelectedItem.ToString());
cmdnewdb.Parameters.AddWithValue("num", number.Text.Trim());
cmdnewdb.Parameters.AddWithValue("ext", extn.Text.Trim());
cmdnewdb.Parameters.AddWithValue("mob", mobile.Text);
cmdnewdb.Parameters.AddWithValue("mail", email.Text.Trim());
cmdnewdb.Parameters.AddWithValue("note", notes.Text.Trim());
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Faculty Details Updated Succesfully", "Update Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
}
else
{
MessageBox.Show("No Records Found", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
facid.SelectAll();
facid.Focus();
dr.Close();
}
con.Close();
}
catch (Exception err)
{
MessageBox.Show("Problem may be due to incorrect ID. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Update method of Faculty Page :" + err.Message);
}
}
}
private void bSearch_Click(object sender, EventArgs e)
{
if (facid.Text == "")
{
MessageBox.Show("Please enter an Faculty ID", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
facid.Focus();
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("select * from faculty where facid=@fid", con);
cmdnewdb.Parameters.AddWithValue("fid", int.Parse(facid.Text.Trim()));
dr = cmdnewdb.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
fname.Text = dr.GetString("fname");
lname.Text = dr.GetString("lname");
number.Text = dr.GetString("number");
desig.Text = dr.GetString("desig");
extn.Text = dr.GetString("extn");
mobile.Text = dr.GetString("mobile");
email.Text = dr.GetString("email");
notes.Text = dr.GetString("notes");
dept.Text = dr.GetString("dept");
dr.Close();
}
else
{
MessageBox.Show("No Records Found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
facid.SelectAll();
facid.Focus();
dr.Close();
}
con.Close();
}
catch (Exception err)
{
MessageBox.Show("Problem may be due to incorrect ID. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Search method of Faculty Page :" + err.Message);
}
}
}
private void bAdd_Click(object sender, EventArgs e)
{
String flist ="", llist= "";
if (locList.Items.Count == 0 || fieldList.Items.Count == 0)
{
MessageBox.Show("Please fill in all the fields.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (locname.SelectedIndex == locname.Items.Count - 1 && others.Text == "")
{
MessageBox.Show("Please enter Other Location.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
//Adding all items of fieldlist to one string variable
for (int fcnt = 0; fcnt < fieldList.Items.Count; fcnt++)
{
flist += fieldList.Items[fcnt].ToString() + ",";
}
//Adding all items of loclist to one string variable
for (int lcnt = 0; lcnt < locList.Items.Count; lcnt++)
{
llist += locList.Items[lcnt].ToString() + ",";
}
con.Open();
cmdnewdb = new MySqlCommand("insert into interest(studid,fieldlist,loclist,comments) values(@sid,@field,@loc,@comm)", con);
cmdnewdb.Parameters.AddWithValue("sid", sid);
cmdnewdb.Parameters.AddWithValue("field", flist);
cmdnewdb.Parameters.AddWithValue("loc", locList.Items);
cmdnewdb.Parameters.AddWithValue("comm", comments.Text.Trim());
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Student Interest Details Added Succesfully", "Add Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
con.Close();
clearControls(sender, e);
}
catch (Exception err)
{
MessageBox.Show("Student Id does not exist. Please provide valid ID.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Add method of StudentInterest Page :" + err.Message);
}//End of Catch
}//End of Outer If-Else
}
private void bDelete_Click(object sender, EventArgs e)
{
int status;
try
{
con.Open();
cmdnewdb = new MySqlCommand("delete from skills where studid=@id", con);
cmdnewdb.Parameters.AddWithValue("id", sid);
status = cmdnewdb.ExecuteNonQuery();
if (status > 0)
{
MessageBox.Show("Knowledge and Skills Details Deleted Succesfully", "Delete Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("No records found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cmdnewdb.Parameters.Clear();
con.Close();
clearControls(sender, e);
}
catch (Exception err)
{
MessageBox.Show("Problem may be: Database Connection doe not exist. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Delete method of Student Skills Page :" + err.Message);
}
}
private void bUpdate_Click(object sender, EventArgs e)
{
if (cid.Text == "" || cfname.Text == "" || clname.Text == "" || cemail.Text == "" || cnum.Text == "" || cpos.Text == "" || ccity.Text == "" || ccntry.Text == "" || cnpos.Text == "" || caddr.Text == "")
{
MessageBox.Show("Please fill in the required fields marked in red.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("update company set cpyname=@name,spocfname=@sf,spoclname=@sl,position=@pos,number=@num,email=@mail,fax=@fx,city=@cty,country=@ctry,zipcode=@zcode,address=@addr,jobsavail=@tot,jobresp=@resp,jobreq=@req,jobdesc=@desc where cmpid=@cid", con);
cmdnewdb.Parameters.AddWithValue("id", cid.Text.Trim());
cmdnewdb.Parameters.AddWithValue("name", cname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("sf", cfname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("sl", clname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("pos", cpos.Text.Trim());
cmdnewdb.Parameters.AddWithValue("num", cnum.Text);
cmdnewdb.Parameters.AddWithValue("mail", cemail.Text);
cmdnewdb.Parameters.AddWithValue("fx", cfax.Text.Trim());
cmdnewdb.Parameters.AddWithValue("cty", ccity.Text);
cmdnewdb.Parameters.AddWithValue("ctry", ccntry.Text);
cmdnewdb.Parameters.AddWithValue("zcode",cpostal.Text==""?0:int.Parse(cpostal.Text));
cmdnewdb.Parameters.AddWithValue("addr", caddr.Text.Trim());
cmdnewdb.Parameters.AddWithValue("tot", int.Parse(cnpos.Text));
cmdnewdb.Parameters.AddWithValue("resp", cresp.Text.Trim());
cmdnewdb.Parameters.AddWithValue("req", creq.Text.Trim());
cmdnewdb.Parameters.AddWithValue("desc", cdesc.Text.Trim());
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Company Details Updated Succesfully", "Update Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
con.Close();
clearControls(sender, e);
}
catch (Exception err)
{
MessageBox.Show("There is a problem with input values. Please provide valid inputs.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Update method of CompanyForm Page :" + err.Message);
}//End of Catch
finally
{
con.Close();
}
}//End of Outer If-Else
}
private void bSearch_Click(object sender, EventArgs e)
{
if (cid.Text != "")
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("select * from company where cmpid=@fid", con);
cmdnewdb.Parameters.AddWithValue("fid", cid.Text.Trim());
dr = cmdnewdb.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
cname.Text = dr.GetString("cpyname");
cfname.Text = dr.GetString("spocfname");
clname.Text = dr.GetString("spoclname");
cnum.Text = dr.GetString("number");
cpos.Text = dr.GetString("position");
cemail.Text = dr.GetString("email");
cpostal.Text = dr.GetString("zipcode");
ccity.Text = dr.GetString("city");
ccntry.Text = dr.GetString("country");
cfax.Text = dr.GetString("fax");
caddr.Text = dr.GetString("address");
cnpos.Text = dr.GetString("jobsavail");
cresp.Text = dr.GetString("jobresp");
creq.Text = dr.GetString("jobreq");
cdesc.Text = dr.GetString("jobdesc");
}
else
{
MessageBox.Show("No records found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dr.Close();
}
}
catch (Exception err)
{
MessageBox.Show("Problem may be due to incorrect ID. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Search method of Student Skills Page :" + err.Message);
}
finally
{
con.Close();
}
}
else
{
MessageBox.Show("Please enter valid company ID.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
cid.SelectAll();
cid.Focus();
}
}
private void getData(String name)
{
DataSet ds = new DataSet();
try
{
con.Open();
cmd = new MySqlCommand("select * from " + name, con);
da = new MySqlDataAdapter(cmd);
da.Fill(ds, name);
dt = ds.Tables[name];
if (dt.Rows.Count < 1)
{
dataGridView1.DataSource = null;
dataGridView1.Refresh();
MessageBox.Show("No Records Found", "Not Found", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
BindingSource bSource = new BindingSource();
bSource.DataSource = dt;
dataGridView1.Refresh();
dataGridView1.DataSource = bSource;
}
con.Close();
}
catch (Exception err)
{
MessageBox.Show("There must be a Database Connection Problem. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "GetData method of Report Page :" + err.Message);
}
}
private void bSearch_Click(object sender, EventArgs e)
{
String[] dlst,mlst,glst,clst,plst,ylst,cname,fdt,tdt,desg,dut;
try
{
con.Open();
cmdnewdb = new MySqlCommand("select * from education where studid=@fid", con);
cmdnewdb.Parameters.AddWithValue("fid", sid.Text.Trim());
dr = cmdnewdb.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
if (dr.GetString("semreg") == "Fall")
optfall.Checked = true;
else
optwinter.Checked = true;
regyr.Text = dr.GetString("semyr");
sfname.Text = dr.GetString("fname");
slname.Text = dr.GetString("lname");
smname.Text = dr.GetString("mname");
semail.Text = dr.GetString("email");
snum.Text = dr.GetString("number");
if (dr.GetString("status") == "International")
status1.Checked = true;
else
status2.Checked = true;
dlst = dr.GetString("degree").Split('/');
cDegree1.Text = dr.GetString(dlst[0]);
cDegree2.Text = dr.GetString(dlst[1]);
cDegree3.Text = dr.GetString(dlst[2]);
cDegree4.Text = dr.GetString(dlst[3]);
mlst = dr.GetString("major").Split('/');
Major1.Text = dr.GetString(mlst[0]);
Major2.Text = dr.GetString(mlst[1]);
Major3.Text = dr.GetString(mlst[2]);
Major4.Text = dr.GetString(mlst[3]);
glst = dr.GetString("gpa").Split('/');
GPA1.Text = dr.GetString(glst[0]);
GPA2.Text = dr.GetString(glst[1]);
GPA3.Text = dr.GetString(glst[2]);
GPA4.Text = dr.GetString(glst[3]);
clst = dr.GetString("college").Split('/');
College1.Text = dr.GetString(clst[0]);
College2.Text = dr.GetString(clst[1]);
College3.Text = dr.GetString(clst[2]);
College4.Text = dr.GetString(clst[3]);
plst = dr.GetString("place").Split('/');
Place1.Text = dr.GetString(plst[0]);
Place2.Text = dr.GetString(plst[1]);
Place3.Text = dr.GetString(plst[2]);
Place4.Text = dr.GetString(plst[3]);
ylst = dr.GetString("year").Split('/');
year1.Text = dr.GetString(ylst[0]);
year2.Text = dr.GetString(ylst[1]);
year3.Text = dr.GetString(ylst[2]);
year4.Text = dr.GetString(ylst[3]);
cname = dr.GetString("compname").Split('/');
tComp1.Text = dr.GetString(cname[0]);
tComp2.Text = dr.GetString(cname[1]);
tComp3.Text = dr.GetString(cname[2]);
fdt = dr.GetString("fromdate").Split('/');
cFrmDt1.Text = dr.GetString(fdt[0].Substring(0,fdt[0].IndexOf('-')));
cFrmDt2.Text = dr.GetString(fdt[1].Substring(0, fdt[1].IndexOf('-')));
cFrmDt3.Text = dr.GetString(fdt[2].Substring(0, fdt[2].IndexOf('-')));
cFrmYr1.Text = dr.GetString(fdt[0].Substring(fdt[0].IndexOf('-'))+1);
cFrmYr2.Text = dr.GetString(fdt[1].Substring(fdt[1].IndexOf('-'))+1);
cFrmYr3.Text = dr.GetString(fdt[2].Substring(fdt[2].IndexOf('-'))+1);
tdt = dr.GetString("todate").Split('/');
cToDt1.Text = dr.GetString(tdt[0].Substring(0, tdt[0].IndexOf('-')));
cToDt2.Text = dr.GetString(tdt[1].Substring(0, tdt[1].IndexOf('-')));
cToDt3.Text = dr.GetString(tdt[2].Substring(0, tdt[2].IndexOf('-')));
cToYr1.Text = dr.GetString(tdt[0].Substring(tdt[0].IndexOf('-')) + 1);
cToYr2.Text = dr.GetString(tdt[1].Substring(tdt[1].IndexOf('-')) + 1);
cToYr3.Text = dr.GetString(tdt[2].Substring(tdt[2].IndexOf('-')) + 1);
desg = dr.GetString("desig").Split('/');
tDesig1.Text = dr.GetString(desg[0]);
tDesig2.Text = dr.GetString(desg[1]);
tDesig3.Text = dr.GetString(desg[2]);
dut = dr.GetString("duties").Split('/');
tDuty1.Text = dr.GetString(dut[0]);
tDuty2.Text = dr.GetString(dut[1]);
tDuty3.Text = dr.GetString(dut[2]);
}
else
{
MessageBox.Show("No records found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dr.Close();
}
con.Close();
}
catch (Exception err)
{
MessageBox.Show("Problem may be due to incorrect ID. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Search method of Student Skills Page :" + err.Message);
}
}
private void bSearch_Click(object sender, EventArgs e)
{
string[] plst, llst,flst,olst,clst;
try
{
con.Open();
cmdnewdb = new MySqlCommand("select * from skills where studid=@fid", con);
cmdnewdb.Parameters.AddWithValue("fid", sid);
dr = cmdnewdb.ExecuteReader();
dr.Read();
if (dr.HasRows)
{
plst = dr.GetString("proglist").Split(',');
clst = dr.GetString("cmslist").Split(',');
olst = dr.GetString("oslist").Split(',');
flst = dr.GetString("fieldlist").Split(',');
llst = dr.GetString("langlist").Split(',');
foreach (String s in plst)
{
plangList.Items.Add(s);
}
foreach (String s in clst)
{
cmsList.Items.Add(s);
}
foreach (String s in olst)
{
osList.Items.Add(s);
}
foreach (String s in flst)
{
fieldList.Items.Add(s);
}
foreach (String s in llst)
{
langList.Items.Add(s);
}
dr.Close();
}
else
{
MessageBox.Show("No records found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
dr.Close();
}
con.Close();
}
catch (Exception err)
{
MessageBox.Show("Problem may be due to incorrect ID. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Search method of Student Skills Page :" + err.Message);
}
}
private void bAdd_Click(object sender, EventArgs e)
{
String degree = "", fromDate = "", todate = "";
if (sid.Text == "" || sfname.Text =="" || slname.Text=="" || semail.Text=="" || snum.Text == "")
{
MessageBox.Show("Please fill in the required fields.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("insert into education(semreg,studid,fname,lname,mname,email,number,status,degree,major,gpa,college,place,year,compname,fromdate,todate,desig,duties,semyr) values(@reg,@id,@name1,@name2,@name3,@mail,@num,@stat,@deg,@maj,@mark,@coll,@loc,@yr,@cname,@fdate,@tdate,@desg,@duty,@semyr)", con);
if (optfall.Checked == true)
{
cmdnewdb.Parameters.AddWithValue("reg", optfall.Text);
}
else if (optwinter.Checked == true)
{
cmdnewdb.Parameters.AddWithValue("reg", optwinter.Text);
}
cmdnewdb.Parameters.AddWithValue("id", int.Parse(sid.Text));
cmdnewdb.Parameters.AddWithValue("name1", sfname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("name2", slname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("name3", smname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("mail", semail.Text.Trim());
cmdnewdb.Parameters.AddWithValue("num", int.Parse(snum.Text));
if (status1.Checked == true)
{
cmdnewdb.Parameters.AddWithValue("stat", status1.Text);
}
else if (status2.Checked == true)
{
cmdnewdb.Parameters.AddWithValue("stat", status2.Text);
}
else
{
cmdnewdb.Parameters.AddWithValue("stat","");
}
degree = cDegree1.SelectedValue + "/" + cDegree2.SelectedValue + "/" + cDegree3.SelectedValue + "/" + cDegree4.SelectedValue;
cmdnewdb.Parameters.AddWithValue("deg", degree);
cmdnewdb.Parameters.AddWithValue("maj", Major1.Text + "/" + Major2.Text + "/" + Major3.Text + "/" + Major4.Text);
cmdnewdb.Parameters.AddWithValue("mark", GPA1.Text + "/" + GPA2.Text + "/" + GPA3.Text + "/" + GPA4.Text);
cmdnewdb.Parameters.AddWithValue("coll", College1.Text + "/" + College2.Text + "/" + College3.Text + "/" + College4.Text);
cmdnewdb.Parameters.AddWithValue("loc", Place1.Text + "/" + Place2.Text + "/" + Place3.Text + "/" + Place4.Text);
cmdnewdb.Parameters.AddWithValue("yr", year1.Text + "/" + year2.Text + "/" + year3.Text + "/" + year4.Text);
cmdnewdb.Parameters.AddWithValue("cname", tComp1.Text + "/" + tComp2.Text + "/" + tComp3.Text);
fromDate = cFrmDt1.SelectedValue + "-" + cFrmYr1.SelectedText + "/"
+ cFrmDt2.SelectedValue + "-" + cFrmYr2.SelectedText + "/"
+ cFrmDt3.SelectedValue + "-" + cFrmYr3.SelectedText;
cmdnewdb.Parameters.AddWithValue("fdate",fromDate);
todate = cToDt1.SelectedValue + "-" + cToYr1.SelectedText + "/"
+ cToDt2.SelectedValue + "-" + cToYr2.SelectedText + "/"
+ cToDt3.SelectedValue + "-" + cToYr3.SelectedText;
cmdnewdb.Parameters.AddWithValue("tdate", todate);
cmdnewdb.Parameters.AddWithValue("desg", tDesig1.Text + "/" + tDesig2.Text + "/" + tDesig3.Text);
cmdnewdb.Parameters.AddWithValue("duty", tDuty1.Text + "/" + tDuty2.Text + "/" + tDuty3.Text);
cmdnewdb.Parameters.AddWithValue("semyr",int.Parse(regyr.Text));
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Student Details Added Succesfully", "Add Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
con.Close();
}
catch (Exception err)
{
MessageBox.Show("There is a problem with input values. Please provide valid inputs.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Add Student method of StudentEducation Page :" + err.Message);
}//End of Catch
}//End of Outer If-Else
}
private void bUpdate_Click(object sender, EventArgs e)
{
String flist = "", llist = "", plist = "", olist = "", clist = "";
if (lang.Items.Count == 0 || langList.Items.Count == 0 || fieldList.Items.Count == 0 || cmsList.Items.Count == 0 || osList.Items.Count == 0)
{
MessageBox.Show("Please fill in all the fields.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (lang.SelectedIndex == lang.Items.Count - 1 && pothers.Text == "")
{
MessageBox.Show("Please Other Programming Language.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (ccms.SelectedIndex == ccms.Items.Count - 1 && cmsother.Text == "")
{
MessageBox.Show("Please Other CMS Name.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (cos.SelectedIndex == cos.Items.Count - 1 && osother.Text == "")
{
MessageBox.Show("Please Other OS Name.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (clang.SelectedIndex == clang.Items.Count - 1 && langother.Text == "")
{
MessageBox.Show("Please Other Language.", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
//Concatenating all items of programming language list
for (int pcnt = 0; pcnt < plangList.Items.Count; pcnt++)
{
if (plist == "")
plist += plangList.Items[pcnt].ToString();
else
plist += "," + plangList.Items[pcnt].ToString();
}
//Concatenating all items of cms list
for (int ccnt = 0; ccnt < cmsList.Items.Count; ccnt++)
{
if (clist == "")
clist += cmsList.Items[ccnt].ToString();
else
clist += "," + cmsList.Items[ccnt].ToString();
}
//Concatenating all items of os list
for (int ocnt = 0; ocnt < osList.Items.Count; ocnt++)
{
if (olist == "")
olist += osList.Items[ocnt].ToString();
else
olist += "," + osList.Items[ocnt].ToString();
}
//Concatenating all items of field list
for (int fcnt = 0; fcnt < fieldList.Items.Count; fcnt++)
{
if (flist == "")
flist += fieldList.Items[fcnt].ToString();
else
flist += "," + fieldList.Items[fcnt].ToString();
}
//Concatenating all items of lang list
for (int gcnt = 0; gcnt < langList.Items.Count; gcnt++)
{
if (llist == "")
llist += langList.Items[gcnt].ToString();
else
llist += "," + langList.Items[gcnt].ToString();
}
con.Open();
cmdnewdb = new MySqlCommand("update skills set proglist=@plst,cmslist=@clst,oslist=@olst,fieldlist=@flst,langlist=@llst where studi=@sid", con);
cmdnewdb.Parameters.AddWithValue("sid", sid);
cmdnewdb.Parameters.AddWithValue("plst", plist);
cmdnewdb.Parameters.AddWithValue("clst", clist);
cmdnewdb.Parameters.AddWithValue("olst", olist);
cmdnewdb.Parameters.AddWithValue("flst", flist);
cmdnewdb.Parameters.AddWithValue("llst", llist);
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Kwowledge and Skills Details Updated Succesfully", "Update Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
con.Close();
clearControls(sender, e);
}
catch (Exception err)
{
MessageBox.Show("There is a problem with input values. Please provide valid inputs.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Update method of StudentKwSkills Page :" + err.Message);
}//End of Catch
}//End of Outer If-Else
}
private void bUpdate_Click(object sender, EventArgs e)
{
if (studstat.Text == "" || tfname.Text == "" || tmname.Text == "" || size.Text == "" || pdesc.Text == "" || tcname.Text == "" || istatus.Text == "" || title.Text == "")
{
MessageBox.Show("Please fill in all the fields before updating.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
try
{
con.Open();
cmdnewdb = new MySqlCommand("update internship set status=@st,cname=@name,mgrname=@mgr,facname=@fac,title=@head,size=@tot,istatus=@istat,pdesc=@desc where studid=@sd", con);
cmdnewdb.Parameters.AddWithValue("sd", sid);
cmdnewdb.Parameters.AddWithValue("st", studstat.SelectedItem.ToString());
cmdnewdb.Parameters.AddWithValue("name", tcname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("mgr", tmname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("fac", tfname.Text.Trim());
cmdnewdb.Parameters.AddWithValue("head", title.Text.Trim());
cmdnewdb.Parameters.AddWithValue("tot", int.Parse(size.Text));
cmdnewdb.Parameters.AddWithValue("istat", istatus.SelectedItem.ToString());
cmdnewdb.Parameters.AddWithValue("desc", pdesc.Text.Trim());
cmdnewdb.ExecuteNonQuery();
MessageBox.Show("Internship Details Updated Succesfully", "Update Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
cmdnewdb.Parameters.Clear();
con.Close();
}
catch (Exception err)
{
MessageBox.Show("Problem may be due to incorrect ID. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Update method of Student Internship Page :" + err.Message);
}
}
}
private void bUpdate_Click(object sender, EventArgs e)
{
int status;
try
{
con.Open();
cmdnewdb = new MySqlCommand("update interest set fieldlist=@flst,loclist=@llst,comments=@com where studid=@id", con);
cmdnewdb.Parameters.AddWithValue("id", sid);
cmdnewdb.Parameters.AddWithValue("flst", fieldList.Text);
cmdnewdb.Parameters.AddWithValue("llst", locList.Text);
cmdnewdb.Parameters.AddWithValue("com", comments.Text);
status = cmdnewdb.ExecuteNonQuery();
if (status > 0)
{
MessageBox.Show("Interest Details Updated Succesfully", "Updated Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("No records found.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
cmdnewdb.Parameters.Clear();
con.Close();
clearControls(sender, e);
}
catch (Exception err)
{
MessageBox.Show("Problem may be: Database Connection doe not exist. Please try again", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
CreateLogFile Err = new CreateLogFile();
Err.ErrorLog("ErrorLog", "Update method of Student Interest Page :" + err.Message);
}
}
