public static bool UpdateDriver(model.Driver driverToBeUpdated)
{
bool result = false;
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>("@Id", driverToBeUpdated.Id));
parameters.Add(new KeyValuePair <string, object>("@Color", driverToBeUpdated.Color));
parameters.Add(new KeyValuePair <string, object>("@Label", driverToBeUpdated.Label));
parameters.Add(new KeyValuePair <string, object>("@Model", driverToBeUpdated.Model));
parameters.Add(new KeyValuePair <string, object>("@Supplier", driverToBeUpdated.Supplier));
try
{
utils.DatabaseHelper.ExecuteNonQuery(parameters, "procDriver_Update", null);
result = true;
}
catch (Exception ex)
{
throw ex;
}
finally { }
return(result);
}
public static model.Driver CreateDriver(model.Driver driver)
{
model.Driver result = new model.Driver();
result = GetDriver(driver);
if (result.Id == 0)
{
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>("@Color", driver.Color));
parameters.Add(new KeyValuePair <string, object>("@Label", driver.Label));
parameters.Add(new KeyValuePair <string, object>("@Model", driver.Model));
parameters.Add(new KeyValuePair <string, object>("@Supplier", driver.Supplier));
try
{
result.Id = (Int32)utils.DatabaseHelper.ExecuteNonQuery(
parameters,
"procDriver_Create",
new KeyValuePair <string, object>("@Id", driver.Id));
driver.Id = result.Id;
result = driver;
}
catch (Exception ex)
{
throw ex;
}
}
return(result);
}
public long CountPayrollByDateWithoutCurrent(DateTime from, DateTime to, model.Driver driver, string currentId)
{
var builder = Builders <model.Payroll> .Filter;
FilterDefinition <model.Payroll> filter = builder.Eq(x => x.From, from) &
builder.Eq(x => x.To, to) &
builder.Eq(x => x.Driver.Id, driver.Id);
if (!string.IsNullOrEmpty(currentId))
{
filter &= !builder.Eq(x => x.Id, currentId);
}
return(context.Payrolls.Find(filter).CountDocuments());
}
public static model.Driver GetDriverById(int id)
{
model.Driver result = new model.Driver();
try
{
}
catch (Exception)
{
throw;
}
finally { }
return(result);
}
public static int InsertDriver(model.Driver driver)
{
int result = 0;
try
{
}
catch (Exception)
{
throw;
}
finally
{
}
return(result);
}
private static model.Driver GetDriver(model.Driver driver)
{
model.Driver result = new model.Driver();
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>("@Color", driver.Color));
parameters.Add(new KeyValuePair <string, object>("@Label", driver.Label));
parameters.Add(new KeyValuePair <string, object>("@Model", driver.Model));
parameters.Add(new KeyValuePair <string, object>("@Supplier", driver.Supplier));
IDataReader reader = null;
try
{
using (reader = utils.DatabaseHelper.ExecuteReader(parameters, "procDriver_Read"))
{
if (reader.Read())
{
result.Id = (int)reader["Id"];
result.Color = reader["Color"].ToString();
result.Label = reader["Label"].ToString();
result.Model = reader["Model"].ToString();
result.Supplier = reader["Supplier"].ToString();
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (reader.IsClosed == false)
{
reader.Close();
reader.Dispose();
}
}
return(result);
}
public static model.Driver GetDriverById(int id)
{
model.Driver result = new model.Driver();
List <KeyValuePair <string, object> > parameters = new List <KeyValuePair <string, object> >();
parameters.Add(new KeyValuePair <string, object>("@id", id));
IDataReader reader = null;
try
{
using (reader = utils.DatabaseHelper.ExecuteReader(parameters, "procDriverId_read"))
{
if (reader.Read())
{
result.Id = (int)reader["Id"];
result.Color = reader["color"].ToString();
result.Label = reader["label"].ToString();
result.Model = reader["model"].ToString();
result.Supplier = reader["supplier"].ToString();
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (reader.IsClosed == false)
{
reader.Close();
reader.Dispose();
}
}
return(result);
}
public List <model.PrintPayrollView> GetListPayroll(DateTime?from, DateTime?to, model.Driver driver)
{
var printPayrollsView = new List <model.PrintPayrollView>();
var builder = Builders <model.Payroll> .Filter;
FilterDefinition <model.Payroll> filter = FilterDefinition <model.Payroll> .Empty;
if (from.HasValue)
{
filter &= builder.Gte("Details.Ticket.Date", from);
}
if (to.HasValue)
{
filter &= builder.Lte("Details.Ticket.Date", to);
}
if (driver != null)
{
filter &= builder.Eq("Driver.SocialSecurity", driver.SocialSecurity);
}
List <model.Payroll> payrolls = context.Payrolls.Find(filter).ToList();
payrolls.ForEach(x =>
{
printPayrollsView.Add(new model.PrintPayrollView()
{
Id = x.Id,
Driver = x.Driver.Fullname,
PaymentWeek = x.From.Date.ToShortDateString() + "-" + x.To.Date.ToShortDateString(),
Rate = x.Rate.ToString("C"),
TotalHours = x.TotalHours.ToString(),
TotalPayment = x.TotalPayment.ToString("C")
});
});
return(printPayrollsView);
}
