private EmployeeMiscellaneous createEmployeeMiscellaneous(Employee employee, Miscellaneous miscellenaous)
{
EmployeeMiscellaneous employeeMiscellaneous = new EmployeeMiscellaneous();
sqlCon.Open();
sqlCmd.CommandText = "INSERT INTO EmployeeMiscellaneous (employeeId, miscellaneousId) "
+ "VALUES (@employeeId, @miscellaneousId);SELECT CAST(scope_identity() AS int)";
sqlCmd.Parameters.AddWithValue("@employeeId", employee.id);
sqlCmd.Parameters.AddWithValue("@miscellaneousId", miscellenaous.id);
employeeMiscellaneous.id = (int)sqlCmd.ExecuteScalar();
sqlCon.Close();
return(employeeMiscellaneous);
}
public Miscellaneous createMiscellaenousByEmployee(Miscellaneous miscellaneous, Employee employee)
{
sqlCon.Open();
sqlCmd.CommandText = "INSERT INTO [Miscellaneous] (name, description, amount, type) VALUES (@name, @description, @amount, @type);SELECT CAST(scope_identity() AS int)";
sqlCmd.Parameters.AddWithValue("@name", miscellaneous.name);
sqlCmd.Parameters.AddWithValue("@description", miscellaneous.description);
sqlCmd.Parameters.AddWithValue("@amount", miscellaneous.amount);
sqlCmd.Parameters.AddWithValue("@type", miscellaneous.type == MiscType.Benefits ? "Benefit" : "Deduction");
miscellaneous.id = (int)sqlCmd.ExecuteScalar();
sqlCmd.Parameters.Clear();
sqlCon.Close();
EmployeeMiscellaneous transportationBenefit = createEmployeeMiscellaneous(employee, miscellaneous);
return(miscellaneous);
}
public Miscellaneous createTransportationBenefit(Employee employee)
{
Miscellaneous transportationAllowance = new Miscellaneous();
sqlCon.Open();
sqlCmd.CommandText = "INSERT INTO Miscellaneous (name, description, amount, type) "
+ "VALUES (@name,@description,@amount,@type);SELECT CAST(scope_identity() AS int)";
sqlCmd.Parameters.AddWithValue("@name", "TransportationAllowance");
sqlCmd.Parameters.AddWithValue("@description", "Transportation Allowance");
sqlCmd.Parameters.AddWithValue("@amount", "0.00");
sqlCmd.Parameters.AddWithValue("@type", "Benefit");
transportationAllowance.id = (int)sqlCmd.ExecuteScalar();
sqlCon.Close();
EmployeeMiscellaneous transportationBenefit = createEmployeeMiscellaneous(employee, transportationAllowance);
return(transportationAllowance);
}
public Miscellaneous createThirteenMonthBenefit(Employee employee)
{
Miscellaneous thirteenMonthPay = new Miscellaneous();
sqlCon.Open();
sqlCmd.CommandText = "INSERT INTO Miscellaneous (name, description, amount, type) "
+ "VALUES (@name,@description,@amount,@type);SELECT CAST(scope_identity() AS int)";
sqlCmd.Parameters.AddWithValue("@name", "ThirteenMonthAllowance");
sqlCmd.Parameters.AddWithValue("@description", "Thirteen Month Allowance starts @" + Convert.ToDateTime(employee.dateEmployed).ToString("MM/dd/yyyy"));
sqlCmd.Parameters.AddWithValue("@amount", "0.00");
sqlCmd.Parameters.AddWithValue("@type", "Benefit");
thirteenMonthPay.id = (int)sqlCmd.ExecuteScalar();
sqlCon.Close();
EmployeeMiscellaneous thirteenMonthBenefit = createEmployeeMiscellaneous(employee, thirteenMonthPay);
return(thirteenMonthPay);
}