public int inserteducation(EducationDetailsModel education)
{
EducationDataAccess edacces = new EducationDataAccess();
int edu = edacces.SaveEducation(education);
return(edu);
}
public ActionResult Edit(int id)
{
EducationDetailsModel edumod = new EducationDetailsModel();
DataTable dbeducation = new DataTable();
using (SqlConnection sqlcon = new SqlConnection(connectionstring))
{
sqlcon.Open();
string editquery = "SELECT * FROM Education_Details WHERE EmployeeID=@EmployeeID";
SqlDataAdapter sqladp = new SqlDataAdapter(editquery, sqlcon);
sqladp.SelectCommand.Parameters.AddWithValue("@EmployeeID", id);
sqladp.Fill(dbeducation);
}
if (dbeducation.Rows.Count == 1)
{
edumod.EmployeeID = Convert.ToInt32(dbeducation.Rows[0][0].ToString());
edumod.CourseType = dbeducation.Rows[0][1].ToString();
edumod.YearOfPass = Convert.ToInt32(dbeducation.Rows[0][2].ToString());
edumod.CourseSpecialisation = dbeducation.Rows[0][3].ToString();
return(View(edumod));
}
else
{
return(RedirectToAction("Index"));
}
}
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);
}
}
public string Editeducation(EducationDetailsModel edumodel)
{
int result = 0;
try
{
sqlConnection = OpenConnection();
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "uspEditEducationDetails";
sqlCommand.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = edumodel.EmployeeID.ToString();
sqlCommand.Parameters.Add("@CourseType", SqlDbType.VarChar).Value = edumodel.CourseType;
sqlCommand.Parameters.Add("@YearOfPass", SqlDbType.Int).Value = edumodel.YearOfPass.ToString();
sqlCommand.Parameters.Add("@CourseSpecialisation", SqlDbType.VarChar).Value = edumodel.CourseSpecialisation;
result = sqlCommand.ExecuteNonQuery();
if (result > 0)
{
return("success");
}
return("failed");
}
catch (Exception ex)
{
return("An error has been occured, please contact administrator:" + ex.Message);
}
finally
{
CloseConncetion(sqlConnection);
}
}
public int SaveEducation(EducationDetailsModel education)
{
int result = 0;
try
{
string connectionstring = "Data Source=RAKI;Initial Catalog=PioneerEmployeeDB;" + "Integrated Security=True";
SqlConnection mysqlconnection = new SqlConnection(connectionstring);
mysqlconnection.Open();
string sqleducationdetails = @"INSERT INTO Education_Details(CourseType,CourseSpecialisation,YearOfPass)VALUES('" + education.CourseType + "'," + "'" + education.CourseSpecialisation + "'," + "" + education.YearOfPass + ")";
SqlCommand command;
command = new SqlCommand(sqleducationdetails, mysqlconnection);
result = command.ExecuteNonQuery();
if (result > 0)
{
MessageBox.Show("Details have been saved Successfully:");
}
mysqlconnection.Close();
}
catch (Exception ex)
{
MessageBox.Show("An error has been occured, please contact the administartor: " + ex.Message);
}
return(result);
}
protected void EmployeeIDDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
EducationDetailsModel educationmodel = new EducationDetailsModel();
EducationDataAccess educationaccess = new EducationDataAccess();
educationmodel = educationaccess.GetEducationDetails(Convert.ToInt32(EmployeeIDDropDownList.SelectedValue));
CourseTypeTextBox.Text = educationmodel.CourseType;
CourseSpecialisationTextBox.Text = educationmodel.CourseSpecialisation;
YearOfPassTextBox.Text = educationmodel.YearOfPass.ToString();
}
public ActionResult Create(EducationDetailsModel edmodel)
{
using (SqlConnection sqlcon = new SqlConnection(connectionstring))
{
sqlcon.Open();
string query = "INSERT INTO Education_Details VALUES(@CourseType,@YearOfPass,@CourseSpecialisation)";
SqlCommand cmd = new SqlCommand(query, sqlcon);
cmd.Parameters.AddWithValue("@CourseType", edmodel.CourseType);
cmd.Parameters.AddWithValue("@YearOfPass", edmodel.YearOfPass);
cmd.Parameters.AddWithValue("@CourseSpecialisation", edmodel.CourseSpecialisation);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("Index"));
}
public void SaveEducational(EducationDetailsModel edu)
{
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 EDUCATIONDETAILS(EmployeeID,CourseType,Yearofpass,Coursespecialization)VALUES(" + edu.EmployeeID + "," + "'" + edu.Coursetype + "'," + "'" + edu.Yearofpass + "'," + "'" + edu.CourseSpecialization + "')";
SqlCommand cmd = new SqlCommand(COMMAND, mysqlconnection);
cmd.ExecuteNonQuery();
mysqlconnection.Close();
}
finally
{
}
}
public ActionResult Edit(EducationDetailsModel edtmodel)
{
using (SqlConnection sqlcon = new SqlConnection(connectionstring))
{
sqlcon.Open();
string edquery = "UPDATE Education_Details SET CourseType=@CourseType,YearOfPass=@YearOfPass,CourseSpecialisation=@CourseSpecialisation WHERE EmployeeID=@EmployeeID";
SqlCommand cmd = new SqlCommand(edquery, sqlcon);
cmd.Parameters.AddWithValue("@EmployeeID", edtmodel.EmployeeID);
cmd.Parameters.AddWithValue("@CourseType", edtmodel.CourseType);
cmd.Parameters.AddWithValue("@YearOfPass", edtmodel.YearOfPass);
cmd.Parameters.AddWithValue("@CourseSpecialisation", edtmodel.CourseSpecialisation);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("Index"));
}
public long EducationSqlConnection(EducationDetailsModel EducationDetailsmodel)
{
SqlConnection mysqlconnection = new SqlConnection();
mysqlconnection.ConnectionString = "Data Source = DESKTOP-6T65F42;" +
"database = PioneerTechConsultancy_Database;Integrated security = SSPI";
mysqlconnection.Open();
SqlCommand EducationDetailCommand = new SqlCommand("INSERT INTO EducationDetail VALUES(" +
"'" + EducationDetailsmodel.CourseType + "','" + EducationDetailsmodel.YearOfPass + "','" + EducationDetailsmodel.CourseSpecialization + "'," +
+EducationDetailsmodel.EmployeeId + ")", mysqlconnection);
long EducationConnection = EducationDetailCommand.ExecuteNonQuery();
mysqlconnection.Close();
return(EducationConnection);
}
private void button4_Click(object sender, EventArgs e)
{
try
{
EducationDetailsModel edu = new EducationDetailsModel()
{
CourseType = CourseTypetextbox.Text,
CourseSpecialisation = CourseSpecialisationtextbox.Text,
YearOfPass = Convert.ToInt32(YearOfPasstextbox.Text),
};
EducationDataAccess education = new EducationDataAccess();
education.SaveEducation(edu);
}
catch (Exception ex)
{
MessageBox.Show("Please enter the values:");
}
}
public EducationDetailsModel GetEducationDetails(int empid)
{
EducationDetailsModel detailsmodel = new EducationDetailsModel();
sqlConnection = OpenConnection();
sqlCommand = new SqlCommand();
sqlCommand.Connection = sqlConnection;
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "uspGetEducationDetails";
sqlCommand.Parameters.Add("@EmployeeID", SqlDbType.Int).Value = Convert.ToInt32(empid);
SqlDataReader educationdatareader = sqlCommand.ExecuteReader();
while (educationdatareader.Read())
{
detailsmodel.EmployeeID = educationdatareader.GetInt32(educationdatareader.GetOrdinal("EmployeeID"));
detailsmodel.CourseType = educationdatareader.GetString(educationdatareader.GetOrdinal("CourseType"));
detailsmodel.CourseSpecialisation = educationdatareader.GetString(educationdatareader.GetOrdinal("CourseSpecialisation"));
detailsmodel.YearOfPass = educationdatareader.GetInt32(educationdatareader.GetOrdinal("YearOfPass"));
}
CloseConncetion(sqlConnection);
return(detailsmodel);
}
protected void EducationalDetailsSave_Click(object sender, EventArgs e)
{
try
{
EducationDetailsModel education = new EducationDetailsModel()
{
CourseType = CourseTypeTextBox.Text,
CourseSpecialisation = CourseTypeTextBox.Text,
YearOfPass = Convert.ToInt32(YearOfPassTextBox.Text),
};
EducationDataAccess educationdata = new EducationDataAccess();
string edsave = educationdata.SaveEducation(education);
if (edsave.Equals("success"))
{
Response.Write("<script>alert('Details have been saved successfully!');</script>");
}
}
catch (Exception ex)
{
//MessageBox.Show("Please enter the values: " + ex.Message);
Response.Write("<script>alert('Please enter the values!" + ex.Message + "');</script>");
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
EducationDetailsModel educationDetailobj = new EducationDetailsModel
{
CourseType = CourseTypeTextBox.Text,
YearOfPass = YearOfPassTextBox.Text,
CourseSpecialization = CourseSpecializationTextBox.Text,
EmployeeId = Convert.ToInt32(EmployeeIdTextBox.Text)
};
EmployeeDataAccessLayer educationDataAccessobj = new EmployeeDataAccessLayer();
long RowsAffected = educationDataAccessobj.EducationSqlConnection(educationDetailobj);
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);
}
}
protected void EducationalDetailsEdit_Click(object sender, EventArgs e)
{
try
{
EducationDetailsModel edmodel = new EducationDetailsModel()
{
CourseType = CourseTypeTextBox.Text,
EmployeeID = Convert.ToInt32(EmployeeIDDropDownList.SelectedValue),
CourseSpecialisation = CourseSpecialisationTextBox.Text,
YearOfPass = Convert.ToInt32(YearOfPassTextBox.Text),
};
EducationDataAccess cmpaccess = new EducationDataAccess();
string ededit = cmpaccess.Editeducation(edmodel);
if (ededit.Equals("success"))
{
Response.Write("<script>alert('Details have been updated successfully!');</script>");
}
}
catch (Exception ex)
{
//MessageBox.Show("Please enter the values: " + ex.Message);
Response.Write("<script>alert('Please enter the values!" + ex.Message + "');</script>");
}
}
