public static int Add(Designations designations)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procDesignations_Designations";
db.cmd.Parameters.AddWithValue("@DesignationName", designations.DesignationName);
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 <Designations> _GetDesignations()
{
List <Designations> designations = new List <Designations>();
try
{
Command = "select * from tblDesignations";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
Designations singleDesignations = new Designations();
singleDesignations.Id = (int)rdr[0];
singleDesignations.DesignationName = rdr[1].ToString();
designations.Add(singleDesignations);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(designations);
}
public static int Add(Employees employees, Designations designations)
{
int retvalue = -1;
employees.DesignationsId = Designations.Add(designations);
retvalue = Employees.Add(employees);
return(retvalue);
}
public static void Update(int id, Designations designations)
{
try
{
db.cmd.CommandText = "update tblDesignations set DesignationName = @DesignationName where Id=@id";
db.cmd.Parameters.AddWithValue("@DesignationName", designations.DesignationName);
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);
}
}
private static List <Employees> _GetEmployees()
{
List <Employees> employees = new List <Employees>();
try
{
Command = @"select * from tblEmployees";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
Employees singleEmployees = new Employees();
singleEmployees.Id = (int)rdr[0];
singleEmployees.RegistrationID = rdr[1].ToString();
singleEmployees.Salary = Convert.ToSingle(rdr[2]);
singleEmployees.IdentityCardUrl = rdr[3].ToString();
singleEmployees.PostalAddress = rdr[4].ToString();
singleEmployees.ResidentialAddress = rdr[5].ToString();
singleEmployees.AggrementUrl = rdr[6].ToString();
singleEmployees.PersonsId = (int)rdr[7];
singleEmployees.DesignationsId = (int)rdr[8];
singleEmployees.EmployeeTypesId = (int)rdr[9];
singleEmployees.LoginDetailsId = (int)rdr[10];
var emptypes = new EmployeeTypes();
singleEmployees.EmployeeTypes = EmployeeTypes.ListOfEmployeeTypes.SingleOrDefault(et => et.Id == singleEmployees.EmployeeTypesId);
var logindetails = new LoginDetails();
singleEmployees.LoginDetails = LoginDetails.ListOfLoginDetails.SingleOrDefault(ld => ld.Id == singleEmployees.LoginDetailsId);
var desig = new Designations();
singleEmployees.Designations = Designations.ListOfDesignations.SingleOrDefault(d => d.Id == singleEmployees.DesignationsId);
var a = Persons.ListOfPersons.SingleOrDefault(p => p.PersonId == singleEmployees.PersonsId);
singleEmployees.FirstName = a.FirstName;
singleEmployees.LastName = a.LastName;
singleEmployees.PersonId = a.PersonId;
singleEmployees.DateOfBirth = a.DateOfBirth;
singleEmployees.CNIC = a.CNIC;
singleEmployees.ImageUrlPath = a.ImageUrlPath;
singleEmployees.Phone1 = a.Phone1;
singleEmployees.Phone2 = a.Phone2;
singleEmployees.GendersId = a.GendersId;
singleEmployees.Genders.Id = a.Genders.Id;
singleEmployees.Genders.GenderName = a.Genders.GenderName;
employees.Add(singleEmployees);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(employees);
}
public Employees()
{
EmployeeTypes = new EmployeeTypes();
LoginDetails = new LoginDetails();
Designations = new Designations();
}
public static void Update(int empId, Employees employees, EmployeeTypes employeeTypes, Designations designations)
{
employees.DesignationsId = Designations.Add(designations);
employees.EmployeeTypesId = EmployeeTypes.Add(employeeTypes);
Employees.Update(empId, employees);
}