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