protected void btn_Confirm_WWS_Click(object sender, EventArgs e)
{
//create a MWS
//perform a check such that the MWS cannot be created if there is
//an existing wws that is within the mws
//create individual wws
UserAccount user = (UserAccount)Session["UserAccountObj"];
MWSBLL mwsbll = new MWSBLL();
WWSBLL wwsbll = new WWSBLL();
MWS mws = mwsbll.DoRetrieveLatestMWSByRId(user.UserId);
if (mws != null && ddlWorkDay.SelectedIndex != 0)
{
WWS wws = wwsbll.DoRetrieveLatestWWSByMwsId(mws.MwsId);
if (DateTime.Parse(txtStartDate.Text) <= wws.WwsDate)
{
lblNoSelection.Text = "You have a current Monthly work schedule in the system. Please retry once the monthly work schedule have been completed!";
}
else if (ddlShift.SelectedItem.Value == "Select" || ddlWorkDay.SelectedItem.Value == "Select")
{
lblNoSelection.Text = "Please select a shift slot and work day!";
}
else
{
createWWSBasedOnDateRange(DateTime.Parse(txtStartDate.Text), DateTime.Parse(txtEndDate.Text), Convert.ToInt32(ddlShift.SelectedValue), Convert.ToInt32(ddlWorkDay.SelectedValue));
lblSuccess.Text = "Successfully created a schedule.";
}
}
else
{
if (ddlShift.SelectedItem.Value == "Select" || ddlWorkDay.SelectedItem.Value == "Select")
{
lblNoSelection.Text = "Please select a shift slot and work day!";
}
else
{
createWWSBasedOnDateRange(DateTime.Parse(txtStartDate.Text), DateTime.Parse(txtEndDate.Text), Convert.ToInt32(ddlShift.SelectedValue), Convert.ToInt32(ddlWorkDay.SelectedValue));
lblSuccess.Text = "Successfully created a schedule.";
}
}
}
public WWS DoRetrieveLatestWWSByMwsId(int mwsId)
{
try
{
using (NpgsqlConnection connection = new NpgsqlConnection())
{
connection.ConnectionString = ConfigurationManager.ConnectionStrings["constr"].ToString();
connection.Open();
NpgsqlCommand cmd = new NpgsqlCommand();
cmd.Connection = connection;
cmd.CommandText = "Select * from WWS WHERE mwsid=@mwsid order by wwsDate DESC";
cmd.CommandType = CommandType.Text;
NpgsqlDataAdapter da = new NpgsqlDataAdapter(cmd);
da.SelectCommand.Parameters.AddWithValue("@mwsid", mwsId);
DataTable dt = new DataTable();
da.Fill(dt);
cmd.Dispose();
connection.Close();
int wwsid = Convert.ToInt32(dt.Rows[0]["wwsid"].ToString());
DateTime wwsdate = DateTime.Parse(dt.Rows[0]["wwsdate"].ToString());
DateTime wwsstartone = DateTime.Parse(dt.Rows[0]["wwsStartTime"].ToString());
DateTime wwsendone = DateTime.Parse(dt.Rows[0]["wwsEndTime"].ToString());
DateTime wwsstarttwo = DateTime.Parse(dt.Rows[0]["wwsStartTimeTwo"].ToString());
DateTime wwsendtwo = DateTime.Parse(dt.Rows[0]["wwsEndTimeTwo"].ToString());
WWS wws = new WWS(wwsid, wwsdate, wwsstartone, wwsendone, wwsstarttwo, wwsendtwo);
return(wws);
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(null);
}
public Main()
{
InitializeComponent();
// Загрузка базы данных
someMessage.Text = WWS.loadData();
// Автоматическая генерация столбцов
dataGridView1.AutoGenerateColumns = true;
// Привязка источника данных
dataGridView1.DataSource = WWS.tickets;
// Назначение имен столбцов
dataGridView1.Columns[0].HeaderText = "Серия";
dataGridView1.Columns[1].HeaderText = "Номер";
dataGridView1.Columns[2].HeaderText = "Откуда";
dataGridView1.Columns[3].HeaderText = "Куда";
dataGridView1.Columns[4].HeaderText = "Время";
dataGridView1.Columns[5].HeaderText = "Документ";
dataGridView1.Columns[6].HeaderText = "Имя";
dataGridView1.Columns[7].HeaderText = "Фамилия";
dataGridView1.Columns[8].HeaderText = "Отчество";
dataGridView1.Columns[9].HeaderText = "Дата рождения";
dataGridView1.Columns[10].HeaderText = "Место";
dataGridView1.Columns[11].HeaderText = "Пол";
// Удалить
deleteButton.Click += Delete_Click;
// Добавить или изменить
openNewWindowButton.Click += OpenNewWindow_Click;
// Сохранить
saveButton.Click += Save_Click;
// Нумерация строк
dataGridView1.RowPrePaint += DataGridView1_RowPrePaint;
}
