private void Savebutton3_Click(object sender, EventArgs e)
{
try
{
CompanyDetailsModel com = new CompanyDetailsModel();
com.EmployeeID = Convert.ToInt32(employeeidtextbox10.Text);
com.Employeename = Employeenametextbox.Text;
com.Contactnumber = Convert.ToInt64(contactnumbertextbox.Text);
com.Location = LocationtextBox.Text;
com.Website = Websitetextbox.Text;
EmployeeDataAcessLayer objcompanydetails = new EmployeeDataAcessLayer();
objcompanydetails.SaveCompany(com);
/*string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
* "Integrated Security=True";
* SqlConnection mysqlconnection = new SqlConnection(connectionstring);
* mysqlconnection.Open();
* string COMMAND = "INSERT INTO COMPANY_DETAILS(EmployeeID,Employeename,contactnumber,Location,Website)VALUES("+EmployeeID+","+"'"+Employeename+"',"+Contactnumber+","+"'"+Location+"',"+"'"+Website+"')";
* SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
* cmd.ExecuteNonQuery();
* mysqlconnection.Close();*/
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
EmployeeDetailsModel emp = new EmployeeDetailsModel();
emp.Firstname = FirstNametextbox.Text;
emp.Lastname = LastNametextbox.Text;
emp.Email = Emailtextbox.Text;
emp.MobileNumber = Convert.ToInt64(MobileNumbertextbox.Text);
emp.AlternateMobileNumber = Convert.ToInt64(AlternateMobileNumbertextbox.Text);
emp.Address1 = Address1textbox.Text;
emp.Address2 = Address2textbox.Text;
emp.CurrentCountry = CurrentCountrytextbox.Text;
emp.HomeCountry = HomeCountrytextbox.Text;
emp.Zipcode = Convert.ToInt32(Zipcodetextbox.Text);
EmployeeDataAcessLayer objemployeedetails = new EmployeeDataAcessLayer();
objemployeedetails.SaveEmployee(emp);
//string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
// "Integrated Security=True";
//SqlConnection mysqlconnection = new SqlConnection(connectionstring);
//mysqlconnection.Open();
//string COMMAND = "INSERT INTO EMPLOYEEDETAILS(FirstName,LastName,EmailId,mobilenumber,Alternatemobilenumber,Address1,Address2,currentcountry,Homecountry,zipcode)VALUES('"+Firstname+"',"+"'"+Lastname+"',"+"'"+Email+"',"+""+MobileNumber+","+""+AlternateMobileNumber+","+"'"+Address1+"',"+"'"+Address2+"',"+"'"+CurrentCountry+"',"+"'"+HomeCountry+"',"+""+Zipcode+")";
//SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
//cmd.ExecuteNonQuery();
//mysqlconnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("error occured:" + ex.Message);
}
}
private void Savebutton7_Click(object sender, EventArgs e)
{
try
{
TechnicalDetailsModel tech = new TechnicalDetailsModel();
tech.EmployeeID = Convert.ToInt32(EmployeeID5textbox.Text);
tech.UI = UItextbox.Text;
tech.ProgrammingLanguages = programminglanguagestextbox.Text;
tech.ORMTechnologies = ORMtechnologiestextbox.Text;
tech.Databases = databasestextBox.Text;
EmployeeDataAcessLayer objtechnicaldetails = new EmployeeDataAcessLayer();
objtechnicaldetails.SaveTechnical(tech);
/* string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
* "Integrated Security=True";
* SqlConnection mysqlconnection = new SqlConnection(connectionstring);
* mysqlconnection.Open(); string COMMAND = "INSERT INTO TECHNICALDETAILS(EmployeeID,UI,ProgrammingLanguages,ORMTechnologies,Databases)VALUES(" +EmployeeID+","+"'" + UI + "',"+"'"+Programminglanguages+"',"+"'" +ORMTechnologies +"',"+"'"+Databases+"')";
* SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
* cmd.ExecuteNonQuery();
* mysqlconnection.Close();*/
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Savebutton9_Click(object sender, EventArgs e)
{
try
{
EducationDetailsModel edu = new EducationDetailsModel();
edu.EmployeeID = Convert.ToInt32(employeeid9textbox.Text);
edu.Coursetype = Coursetypetextbox.Text;
edu.Yearofpass = Convert.ToInt32(yearofpasstextbox.Text);
edu.CourseSpecialization = coursespecializationtextbox.Text;
EmployeeDataAcessLayer objeducationdetails = new EmployeeDataAcessLayer();
objeducationdetails.SaveEducational(edu);
/* string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
* "Integrated Security=True";
* SqlConnection mysqlconnection = new SqlConnection(connectionstring);
* mysqlconnection.Open(); string COMMAND = "INSERT INTO EDUCATIONDETAILS(EmployeeID,CourseType,Yearofpass,Coursespecialization)VALUES("+EmployeeID+","+"'" + Coursetype + "'," + "'" + Yearofpass + "'," + "'" + CourseSpecialization + "')";
* SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
* cmd.ExecuteNonQuery();
* mysqlconnection.Close();*/
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Savebutton5_Click(object sender, EventArgs e)
{
try
{
ProjectDetailsModel pro = new ProjectDetailsModel();
pro.ProjectID = Convert.ToInt32(ProjectIDtextBox.Text);
pro.EmployeeID = Convert.ToInt32(EmployeeID1textbox.Text);
pro.ProjectName = ProjectNametextbox.Text;
pro.ClientName = Clientnametextbox.Text;
pro.Location = Location1textbox.Text;
pro.Role = Roletextbox.Text;
EmployeeDataAcessLayer objprojectdetails = new EmployeeDataAcessLayer();
objprojectdetails.SaveProject(pro);
/*string connectionstring = @"Data Source=DINESH-COMPUTER\MYSQL;Initial Catalog = pioneerdb;" +
* "Integrated Security=True";
* SqlConnection mysqlconnection = new SqlConnection(connectionstring);
* mysqlconnection.Open();
* string COMMAND = "INSERT INTO PROJECTDETAILS(ProjectID,EmployeeID,ProjectName,ClientName,Location,Role)VALUES("+ProjectID+","+""+ EmployeeID + "," + "'" + ProjectName + "'," + "'" + ClientName + "'," + "'" + Location + "'," + "'" + Role + "')";
* SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
* cmd.ExecuteNonQuery();
* mysqlconnection.Close();*/
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
