public static void Update(int id, EmployeeFines empfine)
{
try
{
db.cmd.CommandText = @"update tblEmployeeFines set Fine=@fn,DateTime=@dt,Note=@nt,
AddedByEmployee_ID=@abid,Employee_ID=@empid,FineStatus_ID=@fsid where Id=@id; ";
db.cmd.Parameters.AddWithValue("@fn", empfine.Fine);
db.cmd.Parameters.AddWithValue("@dt", empfine.DateTime);
db.cmd.Parameters.AddWithValue("@nt", empfine.Note);
db.cmd.Parameters.AddWithValue("@abid", empfine.AddedByEmployeesId);
db.cmd.Parameters.AddWithValue("@empid", empfine.EmployeesId);
db.cmd.Parameters.AddWithValue("@fsid", empfine.FineStatusesId);
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 int Add(EmployeeFines employeeFines)
{
int retvalue = -1;
try
{
db.cmd.CommandType = CommandType.StoredProcedure;
db.cmd.CommandText = "procEmployeeFines_AddEmployeeFines";
db.cmd.Parameters.AddWithValue("@Fine", employeeFines.Fine);
db.cmd.Parameters.AddWithValue("@DateTime", employeeFines.DateTime);
db.cmd.Parameters.AddWithValue("@Note", employeeFines.Note);
db.cmd.Parameters.AddWithValue("@AddedByEmployee_ID", employeeFines.AddedByEmployeesId);
db.cmd.Parameters.AddWithValue("@Employee_ID", employeeFines.EmployeesId);
db.cmd.Parameters.AddWithValue("@FineStatus_ID", employeeFines.FineStatusesId);
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 int Add(EmployeeFines employeeFines, FineStatuses fineStatuses)
{
int retvalue = -1;
employeeFines.FineStatusesId = FineStatuses.Add(fineStatuses);
retvalue = EmployeeFines.Add(employeeFines);
return(retvalue);
}
public static float FineAmount(int employeesId, int Month)
{
float emptotal = 0;
var empfine = new EmployeeFines();
var empfinedata = EmployeeFines.ListOfEmployeeFines.
FindAll(e => e.EmployeesId == employeesId &&
Convert.ToDateTime(e.DateTime).Month == Month).
Select(e => e.Fine);
emptotal = empfinedata.Sum();
return(emptotal);
}
//public EmployeeFines()
//{
// Employees = new Employees();
// AddedByEmployees = new Employees();
//}
private static List <EmployeeFines> _GetEmployeeFines()
{
List <EmployeeFines> EmployeeFines = new List <EmployeeFines>();
try
{
Command = "select * from tblEmployeeFines";
db.cmd.CommandText = Command;
db.con.Open();
SqlDataReader rdr = db.cmd.ExecuteReader();
while (rdr.Read())
{
EmployeeFines singleEmployeeFines = new EmployeeFines();
singleEmployeeFines.Id = (int)rdr[0];
singleEmployeeFines.Fine = Convert.ToSingle(rdr[1]);
singleEmployeeFines.DateTime = rdr[2].ToString();
singleEmployeeFines.Note = rdr[3].ToString();
singleEmployeeFines.AddedByEmployeesId = (int)rdr[4];
singleEmployeeFines.EmployeesId = (int)rdr[5];
singleEmployeeFines.FineStatusesId = (int)rdr[6];
var emp = new Employees();
singleEmployeeFines.Employees = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleEmployeeFines.EmployeesId);
var addedbyemp = new Employees();
singleEmployeeFines.Employees = Employees.ListOfEmployees.SingleOrDefault(e => e.Id == singleEmployeeFines.AddedByEmployeesId);
singleEmployeeFines.FineStatuses = FineStatuses.ListOfFineStatuses.SingleOrDefault(f => f.Id == singleEmployeeFines.FineStatusesId);
EmployeeFines.Add(singleEmployeeFines);
}
}
catch (SqlException sqlex)
{
SqlExceptionErrorHandling rh = new SqlExceptionErrorHandling();
rh.GetError(sqlex);
}
finally
{
db.con.Close();
}
return(EmployeeFines);
}
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);
}
public static void Update(int Id, EmployeeFines empfine, FineStatuses finestatus)
{
empfine.FineStatusesId = FineStatuses.Add(finestatus);
EmployeeFines.Update(Id, empfine);
}
