protected void EditButton_Click(object sender, EventArgs e)
{
TechnicalModel model = new TechnicalModel()
{
UI = UITextBox.Text,
ProgrammingLanguage = ProgrammingLanguageTextBox.Text,
DatabaseName = DatabaseTextBox.Text,
EmployeeId = Convert.ToInt32(EmployeeIdDropDownList.Text)
};
int EditEmployeeId = Convert.ToInt32(EditDropDownList.Text);
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = PRAJWOLPC;database = Pioneer_Employee_Database1;Integrated security = SSPI";
SqlCommand cmd = new SqlCommand("UPDATE [TechnicalDetail] SET[UI] = " +
"'" + model.UI + "',[ProgrammingLanguage] = '" + model.ProgrammingLanguage + "',[Database] = '" + model.DatabaseName + "'WHERE EmployeeID = " + EditEmployeeId, mysqlconnection);
mysqlconnection.Open();
int result = cmd.ExecuteNonQuery();
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert(' Technical Details SUCCESSFULLY Edited');", true);
}
public int SaveTechnicalDetails(TechnicalModel technicalModel)
{
var conn = new SqlConnection();
conn.ConnectionString =
"Data Source=BAIBHAV;" +
"Initial Catalog=PioneerConsultancyDatabase;" +
"Integrated security = True;";
using (var com = conn.CreateCommand())
{
com.CommandText =
"INSERT INTO TechnicalDetail VALUES(@UI, @ProgrammingLanguage,@DatabaseName,@employeeId)";
com.Parameters.AddWithValue("@UI", technicalModel.UI);
com.Parameters.AddWithValue("@ProgrammingLanguage", technicalModel.ProgrammingLanguage);
com.Parameters.AddWithValue("@DatabaseName", technicalModel.Database);
com.Parameters.AddWithValue("@employeeId", technicalModel.EmployeeId);
conn.Open();
var result = com.ExecuteNonQuery();
conn.Close();
return(result);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
TechnicalModel myTechnical = new TechnicalModel
{
UI = TextBox1.Text,
ProgrammingLanguage = TextBox2.Text,
Database = TextBox3.Text,
employeeId = Convert.ToInt32(TextBox4.Text)
};
EmployeeDataAccessLayer mytechnical = new EmployeeDataAccessLayer();
int result = mytechnical.TakeTechnicalDetail(myTechnical);
if (result > 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);
}
}
protected void EditDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
TechnicalModel model = new TechnicalModel();
model = GetTechnicalDetails(Convert.ToInt32(EditDropDownList.Text));
UITextBox.Text = model.UI;
ProgrammingLanguageTextBox.Text = model.ProgrammingLanguage;
DatabaseTextBox.Text = model.DatabaseName;
}
public int SaveTechnicalData(TechnicalModel model)
{
int result;
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = PRAJWOLPC;database = Pioneer_Employee_Database1;Integrated security = SSPI";
SqlCommand cmd = new SqlCommand("INSERT INTO TechnicalDetail VALUES('" + model.UI + "','" + model.ProgrammingLanguage + "','" + model.DatabaseName + "'," + model.EmployeeId + ")", mysqlconnection);
mysqlconnection.Open();
result = cmd.ExecuteNonQuery();
return(result);
}
private void button4_Click(object sender, EventArgs e)
{
var technicalModel = new TechnicalModel()
{
UI = UITextBox.Text,
ProgrammingLanguage = ProgrammingLanguageTextBox.Text,
Database = DatabaseTextBox.Text,
EmployeeId = Convert.ToInt32(EmployeeIdTechnicalComboBox.Text)
};
var employeeDataAccessLayer = new EmployeeDataAccessLayer();
var result = employeeDataAccessLayer.SaveTechnicalDetails(technicalModel);
MessageBox.Show(result > 0 ? "Message Saved Successfully" : "Message Did NOT Saved Successfully");
}
public int TakeTechnicalDetail(TechnicalModel myTechnical)
{
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = DESKTOP-1246094;" +
"database = PioneerDataBase1;Integrated security = SSPI";
SqlCommand cmd = new SqlCommand("INSERT INTO TechnicalDetail VALUES(" +
"'" + myTechnical.UI + "','" + myTechnical.ProgrammingLanguage + "','" + myTechnical.Database + "'," + myTechnical.employeeId + ")", mysqlconnection);
//Opening Sql Database Connection
mysqlconnection.Open();
var result = cmd.ExecuteNonQuery();
mysqlconnection.Close();
return(result);
}
private void button3_Click(object sender, EventArgs e)
{
TechnicalModel technicalModel = new TechnicalModel()
{
UI = UITextBox.Text,
ProgrammingLanguage = ProgrammingLanguageTextBox.Text,
DatabaseName = DatabaseTextBox.Text,
EmployeeId = Convert.ToInt32(Employee_TechnicalComboBox.Text)
};
EmployeeDataAccessLayer EmployeeDAL = new EmployeeDataAccessLayer();
int NoOfRowsAffected = EmployeeDAL.SaveTechnicalData(technicalModel);
if (NoOfRowsAffected > 0)
{
MessageBox.Show("Succesfully saved to Technical Detail");
}
else
{
MessageBox.Show("Could Not Save");
}
}
public TechnicalModel GetTechnicalDetails(int employeeid)
{
TechnicalModel empdmodel = new TechnicalModel();
string connectionstring = "Data Source=PRAJWOLPC;Initial Catalog=Pioneer_Employee_Database1;" +
" Integrated Security=SSPI";
SqlConnection mysqlconnection = new SqlConnection(connectionstring);
mysqlconnection.Open();
string sqldetails = ("Select * FROM TechnicalDetail WHERE EmployeeID=" + employeeid);
SqlCommand command;
command = new SqlCommand(sqldetails, mysqlconnection);
SqlDataReader employeedatareader = command.ExecuteReader();
while (employeedatareader.Read())
{
empdmodel.UI = employeedatareader.GetString(employeedatareader.GetOrdinal("UI"));
empdmodel.ProgrammingLanguage = employeedatareader.GetString(employeedatareader.GetOrdinal("ProgrammingLanguage"));
empdmodel.DatabaseName = employeedatareader.GetString(employeedatareader.GetOrdinal("Database"));
}
return(empdmodel);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
TechnicalModel model = new TechnicalModel()
{
UI = UITextBox.Text,
ProgrammingLanguage = ProgrammingLanguageTextBox.Text,
DatabaseName = DatabaseTextBox.Text,
EmployeeId = Convert.ToInt32(EmployeeIdDropDownList.Text)
};
EmployeeDataAccessLayer EmployeeDAL = new EmployeeDataAccessLayer();
int NoOfRowsAffected = EmployeeDAL.SaveTechnicalData(model);
if (NoOfRowsAffected > 0)
{
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert(' Technical Details SUCCESSFULLY Saved');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Operation was", "alert(' Save Unsuccesfull.Please Contact Administrator');", true);
}
}
