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