public override void SaveForm()
{
DaybookModel daybook = (DaybookModel)addDaybookControl.GetFieldValues();
_daybookService.SaveDaybook(daybook);
base.SaveForm();
}
public List <DaybookModel> GetDayBooks(DateTime dateTimeStamp)
{
List <DaybookModel> dbooks = new List <DaybookModel>();
var tblJobs = db.tblJobs.Where(j => j.dtFrom == dateTimeStamp).OrderBy(db => db.JobID).ThenBy(db => db.Time).ToList();
foreach (var job in tblJobs)
{
DaybookModel dbookModel = new DaybookModel(job);
var customer = db.tblCustomers.FirstOrDefault(c => c.CustID == dbookModel.CustomerID);
var truck = db.tblTrucks.FirstOrDefault(t => t.Id == dbookModel.TruckId);
var trailer = db.tblTrailers.FirstOrDefault(t => t.Id == dbookModel.TrailerId);
if (customer != null)
{
dbookModel.Customer = new CustomerModel(customer);
}
if (truck != null)
{
dbookModel.Truck = truck.Name;
}
if (trailer != null)
{
dbookModel.Trailer = trailer.Name;
}
dbooks.Add(dbookModel);
}
return(dbooks);
}
public override void EditForm(object id)
{
int daybookId = (int)id;
DaybookModel job = daybookId == 0 ? new DaybookModel {
JobID = 0, dtFrom = DateTime.Now, dtTo = DateTime.Now
} : _daybookService.GetDayBook(daybookId);
addDaybookControl.PopulateData(job);
base.EditForm(id);
}
public List <DaybookModel> GetDayBooks(int type)
{
List <DaybookModel> dbooks = new List <DaybookModel>();
var tblJobs = type == 0 ? db.tblJobs.ToList() : db.tblJobs.Where(j => j.Type == type).ToList();
foreach (var job in tblJobs)
{
DaybookModel dbookModel = new DaybookModel(job);
var customer = db.tblCustomers.FirstOrDefault(c => c.CustID == dbookModel.CustomerID);
if (customer != null)
{
dbookModel.Customer = new CustomerModel(customer);
}
dbooks.Add(dbookModel);
}
return(dbooks);
}
public List <DaybookModel> GetInvoices(int customerId, DateTime?dateFrom, DateTime?dateTo, int driverId = 0, int truckId = 0, int trailerId = 0)
{
List <DaybookModel> retval = new List <DaybookModel>();
var invoices = customerId == 0 ? db.tblJobs.ToList() : db.tblJobs.Where(j => j.CustomerID == customerId).ToList();
if (dateFrom != null && dateFrom != DateTime.MinValue)
{
invoices = invoices.Where(j => j.dtFrom >= dateFrom).ToList();
}
if (dateFrom != null && dateTo != DateTime.MinValue)
{
invoices = invoices.Where(j => j.dtTo <= dateTo).ToList();
}
if (driverId != 0)
{
invoices = invoices.Where(j => j.DriverID == driverId).ToList();
}
if (truckId != 0)
{
invoices = invoices.Where(j => j.TruckId == truckId).ToList();
}
if (trailerId != 0)
{
invoices = invoices.Where(j => j.TrailerId == trailerId).ToList();
}
foreach (var invoice in invoices)
{
DaybookModel dbookModel = new DaybookModel(invoice);
var customer = db.tblCustomers.FirstOrDefault(c => c.CustID == dbookModel.CustomerID);
if (customer != null)
{
dbookModel.Customer = new CustomerModel(customer);
}
retval.Add(dbookModel);
}
//invoices.ForEach(inv => retval.Add(new DaybookModel(inv)));
return(retval);
}
public override object GetFieldValues()
{
int id = this.hdnJobId.Text == string.Empty ? 0 : Convert.ToInt32(this.hdnJobId.Text);
int customerid = (int)((DWTComboBoxItem)cboCustomer.SelectedItem).Value;
string customerName = (string)((DWTComboBoxItem)cboCustomer.SelectedItem).Text;
int driverId = (int)((DWTComboBoxItem)cboDriver.SelectedItem).Value;
string driverName = (string)((DWTComboBoxItem)cboDriver.SelectedItem).Text;
int truckId = (int)((DWTComboBoxItem)cboTruck.SelectedItem).Value;
int trailerId = (int)((DWTComboBoxItem)cboTrailer.SelectedItem).Value;
string journey = ((DWTComboBoxItem)cboJourney.SelectedItem).Text;
int type = cboImportExport.SelectedItem.ToString().ToUpper() == "IMPORT" ? 1 : 2;
DaybookModel daybookModel = new DaybookModel
{
JobID = id,
Address = txtAddress.Text,
Area = txtArea.Text,
BasePrice = Convert.ToDecimal(txtbasePrice.Text),
CustomerID = customerid,
CustRef = txtCustomerRef.Text,
DriverID = driverId,
dtFrom = dateFrom.DateTime,
dtTo = dateTo.DateTime,
Time = txtTime.Time,
MiscCode = txtMiscCode.Text,
Type = type,
InvoiceNo = txtInvoice.Text,
JobRef = txtJobRef.Text,
Notes = txtGeneralNotes.Text,
Journey = cboJourney.SelectedItem.ToString(),
CustomerName = customerName,
DriverName = driverName,
IsDuplicate = chkDulicate.Checked,
TruckId = truckId,
TrailerId = trailerId,
PinNumber = txtPin.Text, UseReturn = chkUseReturn.Checked
};
return(daybookModel);
}
public DBResult SaveDaybook(DaybookModel job)
{
tblJob tblJob = job.JobID != 0 ? db.tblJobs.FirstOrDefault(j => j.JobID == job.JobID) : new tblJob();
try
{
tblJob.Address = job.Address;
tblJob.Area = job.Area;
tblJob.BasePrice = job.BasePrice;
tblJob.CustomerID = job.CustomerID;
tblJob.CustRef = job.CustRef;
tblJob.CustomerName = job.CustomerName;
tblJob.DriverName = job.DriverName;
tblJob.dtFrom = job.dtFrom;
tblJob.dtTo = job.dtTo;
tblJob.Notes = job.Notes;
tblJob.Time = job.Time;
tblJob.Journey = job.Journey;
tblJob.Type = job.Type;
tblJob.MiscCode = job.MiscCode;
tblJob.TruckId = job.TruckId;
tblJob.PinNumber = job.PinNumber;
tblJob.TrailerId = job.TrailerId;
tblJob.UseReturn = job.UseReturn;
tblJob.JobRef = job.JobRef;
tblJob.InvoiceNo = job.InvoiceNo;
if (job.JobID == 0)
{
tblJob.DriverID = job.DriverID;
db.tblJobs.Add(tblJob);
if (job.UseReturn)
{
var dateFrom = Convert.ToDateTime(tblJob.dtFrom).AddDays(1);
var dateTo = Convert.ToDateTime(tblJob.dtTo).AddDays(1);
var currentDateUsed = dateFrom;
while (currentDateUsed < dateTo)
{
tblJob retJob = new tblJob();
retJob.DriverID = job.DriverID;
retJob.Address = job.Address;
retJob.Area = job.Area;
retJob.BasePrice = job.BasePrice;
retJob.CustomerID = job.CustomerID;
retJob.CustRef = job.CustRef;
retJob.CustomerName = job.CustomerName;
retJob.DriverName = job.DriverName;
retJob.dtFrom = currentDateUsed;
retJob.dtTo = job.dtTo;
retJob.Notes = job.Notes;
retJob.Time = job.Time;
retJob.Journey = job.Journey;
retJob.Type = job.Type;
retJob.MiscCode = dateFrom == dateTo.AddDays(-2) ? string.Format("{0}-RETURNED", job.MiscCode) : job.MiscCode;
retJob.TruckId = job.TruckId;
retJob.PinNumber = job.PinNumber;
retJob.TrailerId = job.TrailerId;
retJob.UseReturn = job.UseReturn;
retJob.JobRef = job.JobRef;
retJob.dtFrom = currentDateUsed;
db.tblJobs.Add(retJob);
currentDateUsed = currentDateUsed.AddDays(1);
}
}
}
else
{
if (job.IsDuplicate)
{
if (tblJob.DriverID == job.DriverID)
{
tblJob.DuplicateOf = job.JobID;
var duplicatesFound = db.tblJobs.Count(j => j.DuplicateOf == job.JobID);
tblJob.DriverName = string.Format("{0} ({1})", job.DriverName, (duplicatesFound + 2));
}
tblJob.DriverID = job.DriverID;
db.tblJobs.Add(tblJob);
}
}
db.SaveChanges();
return(new DBResult {
ReturnCode = ReturnCode.Success
});
}
catch (Exception ex)
{
return(new DBResult {
ReturnCode = ReturnCode.Failed, Message = ex.Message
});
}
}
public override void PopulateData(object data)
{
DaybookModel currentData = (DaybookModel)data;
var customers = _customerService.GetCustomers();
var drivers = _driverService.GetDrivers();
journeys = _journeyService.GetJourneys();
var trucks = _driverService.GetTrucks();
var trailers = _driverService.GetTrailers();
cboCustomer.Items.Clear();
cboDriver.Items.Clear();
cboJourney.Items.Clear();
cboTrailer.Items.Clear();
cboTruck.Items.Clear();
this.txtCustomerRef.Text = string.Empty;
this.txtAddress.Text = string.Empty;
this.txtbasePrice.Text = string.Empty;
this.txtArea.Text = string.Empty;
this.txtGeneralNotes.Text = string.Empty;
this.txtMiscCode.Text = string.Empty;
this.txtInvoice.Text = string.Empty;
this.txtTime.Text = string.Empty;
this.txtJobRef.Text = string.Empty;
this.chkDulicate.Checked = currentData.IsDuplicate;
this.chkUseReturn.Checked = currentData.UseReturn;
int index = 1;
DWTComboBoxItem journeyItem = new DWTComboBoxItem {
Text = "Select Journey", Value = 0
};
cboJourney.Items.Add(journeyItem);
int selectedJourneyIndex = 0;
foreach (var journey in journeys)
{
journeyItem = new DWTComboBoxItem {
Text = journey.Journey, Value = journey.ID
};
cboJourney.Items.Add(journeyItem);
if (journey.Journey == currentData.Journey)
{
selectedJourneyIndex = index;
}
index++;
}
int importExport = Convert.ToInt32(currentData.Type) == 1 ? 0 : 1;
DWTComboBoxItem customerItem = new DWTComboBoxItem {
Text = "Select Customer", Value = 0
};
cboCustomer.Items.Add(customerItem);
index = 1;
int selectedCustomerIndex = 0;
foreach (var customer in customers)
{
customerItem = new DWTComboBoxItem {
Text = customer.Name, Value = customer.CustID
};
cboCustomer.Items.Add(customerItem);
if (customer.CustID == currentData.CustomerID)
{
selectedCustomerIndex = index;
}
index++;
}
DWTComboBoxItem driverItem = new DWTComboBoxItem {
Text = "Select Driver", Value = 0
};
cboDriver.Items.Add(driverItem);
index = 1;
int selectedDriverIndex = 0;
foreach (var driver in drivers)
{
driverItem = new DWTComboBoxItem {
Text = string.Format("{0} {1}", driver.Name, driver.Surname), Value = driver.DriverID
};
cboDriver.Items.Add(driverItem);
if (driver.DriverID == currentData.DriverID)
{
selectedDriverIndex = index;
}
index++;
}
DWTComboBoxItem truckItem = new DWTComboBoxItem {
Text = "Select Truck", Value = 0
};
cboTruck.Items.Add(truckItem);
index = 1;
int selectedTruckIndex = 0;
foreach (var truck in trucks)
{
truckItem = new DWTComboBoxItem {
Text = string.Format("{0}-{1}", truck.Name, truck.TruckNumber), Value = truck.Id
};
cboTruck.Items.Add(truckItem);
if (truck.Id == currentData.TruckId)
{
selectedTruckIndex = index;
}
index++;
}
DWTComboBoxItem trailerItem = new DWTComboBoxItem {
Text = "Select Trailer", Value = 0
};
cboTrailer.Items.Add(trailerItem);
index = 1;
int selectedTrailerIndex = 0;
foreach (var trailer in trailers)
{
trailerItem = new DWTComboBoxItem {
Text = string.Format("{0}-{1}", trailer.Name, trailer.TrailerName), Value = trailer.Id
};
cboTrailer.Items.Add(trailerItem);
if (trailer.Id == currentData.TrailerId)
{
selectedTrailerIndex = index;
}
index++;
}
this.txtCustomerRef.Text = currentData.CustRef;
this.txtAddress.Text = currentData.Address;
this.txtbasePrice.Text = currentData.BasePrice.ToString();
this.txtArea.Text = currentData.Area;
this.txtGeneralNotes.Text = currentData.Notes;
this.txtMiscCode.Text = currentData.MiscCode;
this.txtInvoice.Text = currentData.InvoiceNo;
TimeSpan timeSpan = currentData.Time != null?Convert.ToDateTime(currentData.Time).TimeOfDay : DateTime.Now.TimeOfDay;
this.txtTime.EditValue = Utilities.ConvertTo12HourFormat(timeSpan);
this.cboCustomer.SelectedIndex = selectedCustomerIndex;
this.cboDriver.SelectedIndex = selectedDriverIndex;
this.cboTruck.SelectedIndex = selectedTruckIndex;
this.cboTrailer.SelectedIndex = selectedTrailerIndex;
if (cboJourney.Items.Count > 0 && selectedJourneyIndex < cboJourney.Items.Count)
{
this.cboJourney.SelectedIndex = selectedJourneyIndex;
}
if (cboImportExport.Items.Count > 0)
{
this.cboImportExport.SelectedIndex = importExport;
}
this.txtJobRef.Text = currentData.JobRef;
this.hdnJobId.Text = currentData.JobID.ToString();
this.dateFrom.DateTime = Convert.ToDateTime(currentData.dtFrom);
this.dateTo.DateTime = Convert.ToDateTime(currentData.dtTo);
this.txtPin.Text = currentData.PinNumber;
var addresses = _dayBookService.GetAdresses();
AutoCompleteStringCollection addressSuggestions = new AutoCompleteStringCollection();
addresses.ForEach(add => addressSuggestions.Add(add));
txtAddress.AutoCompleteCustomSource = addressSuggestions;
txtAddress.AutoCompleteMode = AutoCompleteMode.Suggest;
txtAddress.AutoCompleteSource = AutoCompleteSource.CustomSource;
}
