public static int Add(EmployeeAttendanceRecords employeeAttendanceRecords)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procEmployeeAttendanceRecords_AddEmployeeAttendanceRecords";
db.cmd.Parameters.AddWithValue("@Date", employeeAttendanceRecords.Date);
db.cmd.Parameters.AddWithValue("@Employee_ID", employeeAttendanceRecords.EmployeesId);
db.cmd.Parameters.AddWithValue("@EmployeeAttendanceSatus_ID", employeeAttendanceRecords.EmployeesAttendanceStatusesId);
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);
}
public static void Update(int id, EmployeeAttendanceRecords empattrecord)
{
try
{
db.cmd.CommandText = @"update tblEmployeeAttendanceReords set Date=@dt,
Employee_ID=@eid,EmployeeAttendanceSatus_ID=@easid where Id=@id; ";
db.cmd.Parameters.AddWithValue("@dt", empattrecord.Date);
db.cmd.Parameters.AddWithValue("@eid", empattrecord.EmployeesId);
db.cmd.Parameters.AddWithValue("@easid", empattrecord.EmployeesAttendanceStatusesId);
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 static float AmountDetection(int employeesId, int Month)
{
var empatt = new EmployeeAttendanceRecords();
var emp = new Employees();
var absentRecordCount = EmployeeAttendanceRecords
.ListOfEmployeeAttendanceRecords
.FindAll(rdr => rdr.EmployeesId == employeesId &&
rdr.EmployeesAttendanceStatusesId == 2 &&
Convert.ToDateTime(rdr.Date).Month == Month)
.Count;
var empSalary = (Employees.ListOfEmployees.SingleOrDefault(e => e.Id == employeesId)).Salary;
var detectionAmount = 0f;
if (absentRecordCount > 3)
{
var detecDayscount = absentRecordCount - 3;
float a = empSalary;
float b = 30f;
float c = detecDayscount;
detectionAmount = (a / b) * c;
}
else
{
detectionAmount = 0;
}
return(detectionAmount);
}
public static int Add(EmployeeAttendanceRecords employeeAttendanceRecords, EmployeeAttendanceStatuses employeeAttendanceStatuses)
{
int retvalue = -1;
employeeAttendanceRecords.EmployeesAttendanceStatusesId = EmployeeAttendanceStatuses.Add(employeeAttendanceStatuses);
retvalue = EmployeeAttendanceRecords.Add(employeeAttendanceRecords);
return(retvalue);
}
//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);
}
public static int Add(SalaryRecords salaryRecords)
{
int retvalue = -1;
try
{
int month = Convert.ToDateTime(salaryRecords.DateTime).Month;
Employees emp1 = new Employees();
EmployeeAttendanceRecords empr1 = new EmployeeAttendanceRecords();
EmployeeFines empf1 = new EmployeeFines();
salaryRecords.PayableAmount = Convert.ToDecimal(Employees.ListOfEmployees.SingleOrDefault(e => e.Id == salaryRecords.EmployeesId).Salary - EmployeeAttendanceRecords.AmountDetection(salaryRecords.EmployeesId, month) - EmployeeFines.FineAmount(salaryRecords.EmployeesId, month));
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procSalaryRecords_AddSalaryRecords";
db.cmd.Parameters.AddWithValue("@DateTime", salaryRecords.DateTime);
db.cmd.Parameters.AddWithValue("@Paid", salaryRecords.Paid);
db.cmd.Parameters.AddWithValue("@PayableAmount", salaryRecords.PayableAmount);
db.cmd.Parameters.AddWithValue("@Employee_ID", salaryRecords.EmployeesId);
db.cmd.Parameters.AddWithValue("@AddedByEmployee_ID", salaryRecords.AddedByEmployesId);
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);
}
