public static int Add(Qualifications qualifications) { int retvalue = -1; try { db.cmd.CommandType = CommandType.StoredProcedure; db.cmd.CommandText = "procQualifications_AddQualifications "; db.cmd.Parameters.AddWithValue("@QualificationName", qualifications.QualificationName); db.cmd.Parameters.Add("@Id", SqlDbType.Int); db.cmd.Parameters["@Id"].Direction = ParameterDirection.Output; db.con.Open(); db.cmd.ExecuteNonQuery(); retvalue = Convert.ToInt32(db.cmd.Parameters["@Id"].Value); } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.CloseDb(db.con, db.cmd); } return(retvalue); }
private static List <Qualifications> _GetQualifications() { List <Qualifications> Qualifications = new List <Qualifications>(); try { Command = "select * from tblQualifications"; db.cmd.CommandText = Command; db.con.Open(); SqlDataReader rdr = db.cmd.ExecuteReader(); while (rdr.Read()) { Qualifications singleQualifications = new Qualifications(); singleQualifications.Id = (int)rdr[0]; singleQualifications.QualificationName = rdr[1].ToString(); Qualifications.Add(singleQualifications); } } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.con.Close(); } return(Qualifications); }
public static int Add(EmployeeQualifications employeeQualifications, Qualifications qualifications) { int retvalue = -1; employeeQualifications.QualificationsId = Qualifications.Add(qualifications); retvalue = EmployeeQualifications.Add(employeeQualifications); return(retvalue); }
public static void Update(int id, Qualifications qualifications) { try { db.cmd.CommandText = "update tblQualifications set QualificationName = @QualificationName where Id=@id"; db.cmd.Parameters.AddWithValue("@Qualificationname", qualifications.QualificationName); db.cmd.Parameters.AddWithValue("@id", id); db.con.Open(); db.cmd.ExecuteNonQuery(); } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.CloseDb(db.con, db.cmd); } }
//public EmployeeQualifications() //{ // Employees = new Employees(); // Qualifications = new Qualifications(); //} private static List <EmployeeQualifications> _GetEmployeeQualifications() { List <EmployeeQualifications> EmployeeQualifications = new List <EmployeeQualifications>(); try { Command = "select * from tblEmployeeQualifications"; db.cmd.CommandText = Command; db.con.Open(); SqlDataReader rdr = db.cmd.ExecuteReader(); while (rdr.Read()) { EmployeeQualifications singleEmployeeQualifications = new EmployeeQualifications(); singleEmployeeQualifications.Id = (int)rdr[0]; singleEmployeeQualifications.EmployeesId = (int)rdr[1]; singleEmployeeQualifications.QualificationsId = (int)rdr[2]; var emp = new Employees(); singleEmployeeQualifications.Employees = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleEmployeeQualifications.EmployeesId); var qualification = new Qualifications(); singleEmployeeQualifications.Qualifications = Qualifications.ListOfQualifications.SingleOrDefault(q => q.Id == singleEmployeeQualifications.QualificationsId); EmployeeQualifications.Add(singleEmployeeQualifications); } } catch (SqlException sqlex) { SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling(); rh.GetError(sqlex); } finally { db.con.Close(); } return(EmployeeQualifications); }
public static void Update(int id, EmployeeQualifications empQuall, Qualifications qual) { Update(id, empQuall); Qualifications.Add(qual); }