/// <summary>
/// copy chargeable record into a manager chargeable record
/// </summary>
/// <param name="j"></param>
public void copyToManagerChargeable(ChargeableJob j)
{
using (var context = new PetoEntities())
{
try
{
ManagerChargeable m = new ManagerChargeable();
m.BillingHours = j.EmpHours;
m.PayRollHours = j.EmpHours;
m.BillingAccomodation = j.Accomodations;
m.PayRollAccomodation = j.Accomodations;
m.BillingTravelDistance = j.TravelDistance;
m.PayRollTravelDistance = j.TravelDistance;
m.TruckDistance = j.TruckDistance;
m.TimeSheetId = j.TimeSheetId;
m.ProjectId = j.ProjectId.Value;
m.Classification = j.Classification;
m.Activity = j.Activity;
m.Day = j.Day;
m.Remarks = j.Remarks;
context.ManagerChargeables.AddObject(m);
context.SaveChanges();
}
catch (Exception)
{
throw;
}
}
}
/// <summary>
/// Deprecated Method for adding a new object to the ManagerChargeables EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToManagerChargeables(ManagerChargeable managerChargeable)
{
base.AddObject("ManagerChargeables", managerChargeable);
}
/// <summary>
/// Create a new ManagerChargeable object.
/// </summary>
/// <param name="managerChargeableId">Initial value of the ManagerChargeableId property.</param>
/// <param name="timeSheetId">Initial value of the TimeSheetId property.</param>
/// <param name="day">Initial value of the Day property.</param>
/// <param name="projectId">Initial value of the ProjectId property.</param>
/// <param name="classification">Initial value of the Classification property.</param>
/// <param name="activity">Initial value of the Activity property.</param>
public static ManagerChargeable CreateManagerChargeable(global::System.Int32 managerChargeableId, global::System.Int32 timeSheetId, global::System.String day, global::System.Int32 projectId, global::System.String classification, global::System.String activity)
{
ManagerChargeable managerChargeable = new ManagerChargeable();
managerChargeable.ManagerChargeableId = managerChargeableId;
managerChargeable.TimeSheetId = timeSheetId;
managerChargeable.Day = day;
managerChargeable.ProjectId = projectId;
managerChargeable.Classification = classification;
managerChargeable.Activity = activity;
return managerChargeable;
}
/// <summary>
/// create manager chargeable job in db
/// </summary>
/// <param name="j"></param>
public string createManagerChargeable(string bHours, string bAccom, string bDist, string truckDist, string bMisc,
string day, string projectNo, string classification, string activity, int timesheetID, string remarks, ref decimal hoursLBL, ref int distLBL, ref int truckLBL, ref decimal expenseLBL)
{
using (var context = new PetoEntities())
{
try
{
if (timesheetID > 0 && bHours != "0" && bHours != string.Empty || bAccom != "0" && bAccom != string.Empty || bDist != "0" && bDist != string.Empty || bMisc != "0" && bMisc != string.Empty || truckDist != "0" && truckDist != string.Empty)
{
ManagerChargeable c = new ManagerChargeable();
// Hours
if (bHours != "0" && bHours != string.Empty)
{
c.BillingHours = Convert.ToDecimal(bHours);
if (c.BillingHours.HasValue)
{
hoursLBL += c.BillingHours.Value;
}
}
// Accomodation
if (bAccom != "0" && bAccom != string.Empty)
{
c.BillingAccomodation = Convert.ToDecimal(bAccom);
expenseLBL += Convert.ToDecimal(c.BillingAccomodation);
}
// Distance
if (bDist != "0" && bDist != string.Empty)
{
c.BillingTravelDistance = Convert.ToInt32(bDist);
distLBL += Convert.ToInt32(bDist);
}
// truck distance
if (truckDist != "0" && truckDist != string.Empty)
{
c.TruckDistance = Convert.ToInt32(truckDist);
truckLBL += Convert.ToInt32(truckDist);
}
// Misc
if (bMisc != "0" && bMisc != string.Empty)
{
c.BillingMisc = Convert.ToDecimal(bMisc);
expenseLBL += Convert.ToDecimal(c.BillingMisc);
}
if (remarks != string.Empty)
{
c.Remarks = remarks;
}
if (c.BillingHours > 0 || c.BillingTravelDistance > 0 || c.BillingAccomodation > 0 || c.BillingMisc > 0 || c.TruckDistance > 0)
{
c.Day = day;
c.ProjectId = idForProjectNo(projectNo);
if (classification != "Select")
{
c.Classification = classification;
}
c.Activity = activity;
c.TimeSheetId = Convert.ToInt32(timesheetID);
context.ManagerChargeables.AddObject(c);
context.SaveChanges();
return "Data was successfully saved";
}
else
{
return "Data was not Entered in input fields.";
}
}
else
{
return "Input values are empty";
}
}
catch (Exception)
{
throw;
}
}
}
