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>"); } }