private void loadTable()
{
ScheduleDatabase scheduleDatabase = new ScheduleDatabase();
rptTable.DataSource = scheduleDatabase.getAllSchedules();
rptTable.DataBind();
}
protected void SearchContainer_Click(object sender, EventArgs e)
{
ScheduleDatabase scheduleDatabase = new ScheduleDatabase();
System.Console.Write(Country.SelectedValue);
rptTable.DataSource = scheduleDatabase.searchSchedule(departureDate.Text, countryId);
rptTable.DataBind();
}
static void Main(string[] args)
{
var excelParser = new ExcelParser();
var excelRowConverter = new ExcelRowConverter();
var db = new ScheduleDatabase();
var path = @"C:\Users\Pavel\courses\Расписание";
var fileNames = Directory.GetFiles(path);
foreach (var fileName in fileNames)
{
var rows = excelParser.Parse(fileName, true, true);
var groupNumber = Path.GetFileNameWithoutExtension(fileName);
var lessons = excelRowConverter.Convert(groupNumber, rows);
db.BulkInsert(lessons);
}
}
protected void Book_Click(object sender, EventArgs e)
{
SchdeuleModel schdeuleModel = new SchdeuleModel();
schdeuleModel.DepartureDate = departureDate.Text;
schdeuleModel.DepartureCountryId = int.Parse(DepartureCountry.SelectedValue);
schdeuleModel.ArrivalCountryID = int.Parse(ArrivalCountry.SelectedValue);
schdeuleModel.Capacity = int.Parse(capacity.Text);
schdeuleModel.ContainerId = int.Parse(Container.SelectedValue);
schdeuleModel.ShippingStatus = 1;
ScheduleDatabase scheduleDatabase = new ScheduleDatabase();
if (scheduleDatabase.saveSchedule(schdeuleModel))
{
scheduleDatabase.updateContainerStatus(1, schdeuleModel.ContainerId);
loadTable();
}
else
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
CountryDatabase countryDatabase = new CountryDatabase();
ContainerDatabase containerDatabase = new ContainerDatabase();
Container.DataSource = containerDatabase.getAllContainer();
Container.DataTextField = "container_number";
Container.DataValueField = "id";
Container.DataBind();
DepartureCountry.DataSource = countryDatabase.getAllCountry();
DepartureCountry.DataTextField = "country";
DepartureCountry.DataValueField = "id";
DepartureCountry.DataBind();
ArrivalCountry.DataSource = countryDatabase.getAllCountry();
ArrivalCountry.DataTextField = "country";
ArrivalCountry.DataValueField = "id";
ArrivalCountry.DataBind();
loadTable();
if (Request.QueryString["id"] != null)
{
ScheduleDatabase scheduleDatabase = new ScheduleDatabase();
if (scheduleDatabase.updateShippingStatus(int.Parse(Request.QueryString["id"]), 2))
{
if (scheduleDatabase.updateContainerStatus(int.Parse(Request.QueryString["container-id"]), 0))
{
loadTable();
}
}
}
}
