/// <summary>
/// Добавляем нового водителя в заданную бд
/// </summary>
/// <param name="companyNumber"></param>
public void AddNewDriver(DriversView driver, int companyNumber)
{
ISession session = (companyNumber == 2)
? NhibernateHelper.OpenTaxiTwoSession()
: NhibernateHelper.OpenTaxiOneSession();
using (var tr = session.BeginTransaction())
{
try
{
//session.CreateQuery(string.Format("EXEC AddNewDriver N'{0}', N'{1}', N'{2}', {3}",
// driver.DriverName, driver.CarTypeName, driver.CarColor, driver.CarNumber));
var list = session.CreateSQLQuery("exec AddNewDriver ?, ?, ?, ?")
.AddEntity(typeof(Drivers))
.SetString(0, driver.DriverName)
.SetString(1, driver.CarTypeName)
.SetString(2, driver.CarColor)
.SetInt32(3, driver.CarNumber)
.List <Drivers>();
tr.Commit();
}
catch (Exception e)
{
tr.Rollback();
}
}
session.Dispose();
}
/// <summary>
/// Switches the view between master/detail
/// </summary>
/// <param name="view">Enum value of the view</param>
private void ShowView(DriversView view)
{
switch (view)
{
case DriversView.Grid:
// Show grid
gvDrivers.Visible = true;
Button1.Visible = true;
// Refresh grid
this.RefreshGrid();
// Hide details
ucDriverInfo.Visible = false;
break;
case DriversView.Details:
// Hide grid
gvDrivers.Visible = false;
// Show details
Button1.Visible = false;
ucDriverInfo.Visible = true;
break;
}
}
public FrmDriversReports(List <Driver> drivers, DriversView driversView, DriverCategoryFilter filter)
{
InitializeComponent();
ReportingDrivers = drivers.GetReportingDrivers();
DriversView = driversView;
CategoryFilter = filter;
}
private void BtnAdd_Click(object sender, EventArgs e)
{
int result;
DriversView newDriver = new DriversView
{
DriverName = textBoxName.Text,
CarTypeName = textBoxCarType.Text,
CarColor = textBoxCarColor.Text,
CarNumber = (int.TryParse(textBoxCarNumber.Text, out result)) ? result : 0
};
DataBaseHelper.GetCurrentDataBase().AddNewDriver(newDriver, _companyNumber);
}
/// <summary>
/// Get the text to display in the user interface.
/// </summary>
/// <param name="driversView">The <see cref="DriversView"/> to determine display text.</param>
/// <returns>The text to display in the user interface.</returns>
public static string GetDisplayText(this DriversView driversView)
{
switch (driversView)
{
case DriversView.AllDrivers:
return("Todos los choferes");
case DriversView.DriversWithoutIssues:
return("Choferes sin problemas");
case DriversView.DriversWithWarnings:
return("Choferes con advertencias");
case DriversView.DriversWithIssues:
return("Choferes con atributos expirados");
default:
return("<No se encuentra el texto>");
}
}
/// <summary>
/// Sets the current Driver's view.
/// </summary>
/// <param name="driversView">The new Driver's view.</param>
private void SetDriversView(DriversView driversView)
{
switch (driversView)
{
case DriversView.AllDrivers:
SelectDriversView(todosLosChoferesToolStripMenuItem, new EventArgs());
break;
case DriversView.DriversWithoutIssues:
SelectDriversView(choferessinProblemasToolStripMenuItem, new EventArgs());
break;
case DriversView.DriversWithWarnings:
SelectDriversView(choferesConAdvertenciasToolStripMenuItem, new EventArgs());
break;
case DriversView.DriversWithIssues:
SelectDriversView(choferesConProblemasToolStripMenuItem, new EventArgs());
break;
default:
break;
}
}
/// <summary>
/// Update the info showed in the status bar.
/// </summary>
private void UpdateStatusBarInfo()
{
stlbShowStatics.Text = $"Mostrando {lvDriversList.Items.Count} chofer{(lvDriversList.Items.Count == 1 ? "" : "es")} de {LoadedDrivers.Count} cargado{(LoadedDrivers.Count == 1 ? "" : "s")}.";
stlbDriversView.Text = $"Visualizando: {DriversView.GetDisplayText()}.";
stlbDriverCategoryFilter.Text = $"Filtrando por: {DriverCategoryFilter.GetDisplayText()}.";
}
/// <summary>
/// Switches the view between master/detail
/// </summary>
/// <param name="view">Enum value of the view</param>
private void ShowView(DriversView view)
{
switch (view)
{
case DriversView.Grid:
// Show grid
gvDrivers.Visible = true;
Button1.Visible = true;
// Refresh grid
this.RefreshGrid();
// Hide details
ucDriverInfo.Visible = false;
break;
case DriversView.Details:
// Hide grid
gvDrivers.Visible = false;
// Show details
Button1.Visible = false;
ucDriverInfo.Visible = true;
break;
}
}
