public static int Add(EmployeeAttendanceStatuses employeeattendancestatuses)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procEmployeeAttendanceStatuses_AddEmployeeAttendanceStatuses";
db.cmd.Parameters.AddWithValue("@StatusName", employeeattendancestatuses.StatusName);
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 <EmployeeAttendanceStatuses> _GetEmployeeAttendanceStatuses()
{
List <EmployeeAttendanceStatuses> EmployeeAttendanceStatuses = new List <EmployeeAttendanceStatuses>();
try
{
Command = "select * from tblEmployeeAttendanceStatuses";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
EmployeeAttendanceStatuses singleEmployeeAttendanceStatuses = new EmployeeAttendanceStatuses();
singleEmployeeAttendanceStatuses.Id = (int)rdr[0];
singleEmployeeAttendanceStatuses.StatusName = rdr[1].ToString();
EmployeeAttendanceStatuses.Add(singleEmployeeAttendanceStatuses);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(EmployeeAttendanceStatuses);
}
public static int Add(EmployeeAttendanceRecords employeeAttendanceRecords, EmployeeAttendanceStatuses employeeAttendanceStatuses)
{
int retvalue = -1;
employeeAttendanceRecords.EmployeesAttendanceStatusesId = EmployeeAttendanceStatuses.Add(employeeAttendanceStatuses);
retvalue = EmployeeAttendanceRecords.Add(employeeAttendanceRecords);
return(retvalue);
}
public static void Update(int id, EmployeeAttendanceStatuses employeeattendancestatuses)
{
try
{
db.cmd.CommandText = "update tblEmployeeAttendanceStatuses set StatusName = @StatusName where Id=@id";
db.cmd.Parameters.AddWithValue("@Statusname", employeeattendancestatuses.StatusName);
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 EmployeeAttendanceRecords()
//{
// Employees = new Employees();
// EmployeeAttendanceStatuses = new EmployeeAttendanceStatuses();
//}
private static List <EmployeeAttendanceRecords> _GetEmployeeAttendanceRecords()
{
List <EmployeeAttendanceRecords> EmployeeAttendanceRecords = new List <EmployeeAttendanceRecords>();
try
{
Command = "select * from tblEmployeeAttendanceReords";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
EmployeeAttendanceRecords singleEmployeeAttendanceRecords = new EmployeeAttendanceRecords();
singleEmployeeAttendanceRecords.Id = (int)rdr[0];
singleEmployeeAttendanceRecords.Date = rdr[1].ToString();
singleEmployeeAttendanceRecords.EmployeesId = (int)rdr[2];
singleEmployeeAttendanceRecords.EmployeesAttendanceStatusesId = (int)rdr[3];
var emp = new Employees();
singleEmployeeAttendanceRecords.Employees = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleEmployeeAttendanceRecords.EmployeesId);
var empattstat = new EmployeeAttendanceStatuses();
singleEmployeeAttendanceRecords.EmployeeAttendanceStatuses = EmployeeAttendanceStatuses.ListOfEmployeeAttendanceStatuses.SingleOrDefault(eas => eas.Id == singleEmployeeAttendanceRecords.EmployeesAttendanceStatusesId);
EmployeeAttendanceRecords.Add(singleEmployeeAttendanceRecords);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(EmployeeAttendanceRecords);
}
