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);
}
}
public long TechnicalSqlConnection(TechnicalDetailsModel TechnicalDetailsmodel)
{
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = DESKTOP-6T65F42;" +
"database = PioneerTechConsultancy_Database;Integrated security = SSPI";
mysqlconnection.Open();
SqlCommand TechnicalDetailCommand = new SqlCommand("INSERT INTO TechnicalDetail VALUES(" +
"'" + TechnicalDetailsmodel.UserInterface + "','" + TechnicalDetailsmodel.ProgrammingLanguages + "','" + TechnicalDetailsmodel.Database + "'," + TechnicalDetailsmodel.EmployeeId + ")", mysqlconnection);
long TechnicalConnection = TechnicalDetailCommand.ExecuteNonQuery();
mysqlconnection.Close();
return(TechnicalConnection);
}
public void SaveTechnical(TechnicalDetailsModel tech)
{
try
{
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(" + tech.EmployeeID + "," + "'" + tech.UI + "'," + "'" + tech.ProgrammingLanguages + "'," + "'" + tech.ORMTechnologies + "'," + "'" + tech.Databases + "')";
SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
cmd.ExecuteNonQuery();
mysqlconnection.Close();
}
finally
{
}
}
private void technicalDetailsSaveButton_Click(object sender, EventArgs e)
{
try
{
TechnicalDetailsModel TechnicalDetailsobj = new TechnicalDetailsModel
{
UserInterface = userInterfaceTextBox.Text,
ProgrammingLanguages = programmingLanguagesTextBox.Text,
Database = databaseTextBox.Text,
EmployeeId = Convert.ToInt32(TechnicalDetailEmployeeIdTextBox.Text)
};
EmployeeDataAccessLayer employeeDataAccessobj = new EmployeeDataAccessLayer();
long RowsAffected_technicalDetails = employeeDataAccessobj.TechnicalSqlConnection(TechnicalDetailsobj);
}
catch (Exception exception)
{
MessageBox.Show("An Error has Occured, Please contact the Administrator!" + exception.Message);
}
finally
{
}
}
protected void Save_Click(object sender, EventArgs e)
{
TechnicalDetailsModel technicalDetailobj = new TechnicalDetailsModel
{
UserInterface = UITextBox.Text,
ProgrammingLanguages = ProgrammingLanguageTextBox.Text,
Database = DatabaseTextBox.Text,
EmployeeId = Convert.ToInt32(EmployeeIdTextBox.Text)
};
EmployeeDataAccessLayer technicalDataAccessobj = new EmployeeDataAccessLayer();
long RowsAffected = technicalDataAccessobj.TechnicalSqlConnection(technicalDetailobj);
if (RowsAffected > 0)
{
string display = "Successful!";
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true);
}
else
{
string display = "UnSuccessful!";
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert('" + display + "');", true);
}
}
