private void видалитиToolStripMenuItem_Click_1(object sender, EventArgs e)
{
try
{
var DelTime = Convert.ToDateTime(DateGridView.SelectedRows[0].Cells[0].Value);
var DelIdShow = Convert.ToInt32(DateGridView.SelectedRows[0].Cells[3].Value);
var res = MessageBox.Show($"Видалити {DelTime} ?", "", MessageBoxButtons.YesNo);
if (res == DialogResult.Yes)
{
for (int i = program.dateList.Count - 1; i >= 0; i--)
{
if (program.dateList[i].StartTime == DelTime && program.dateList[i].Id == DelIdShow)
{
program.dateList.RemoveAt(i);
}
}
DateGridView.Rows.Remove(DateGridView.SelectedRows[0]);
program.IsDirty = true;
}
}
catch (Exception)
{
MessageBox.Show("Нічого не виділено. Виделіть весь рядок для видалення!");
if (DateGridView.Visible == false)
{
DateGridView.Show();
TVshowGridView.Hide();
}
}
}
private void TVshowListToolStripMenuItem_Click(object sender, EventArgs e)
{
SearchBox.Show();
FillFav();
TvshowGridView.Show();
DateGridView.Hide();
FavGridView.Hide();
}
private void favouriteToolStripMenuItem1_Click(object sender, EventArgs e)
{
FavGridView.Rows.Clear();
FillFav();
DateGridView.Hide();
TvshowGridView.Hide();
FavGridView.Show();
}
//сортування
private void SortToolStripMenuItem_Click(object sender, EventArgs e)
{
dt.DefaultView.Sort = "";
FillTVshow();
SearchBox.Hide();
DateGridView.Hide();
FavGridView.Hide();
TvshowGridView.Show();
}
private void всіДатиToolStripMenuItem_Click(object sender, EventArgs e)
{
dtDate.Clear();
foreach (Date i in program.dateList)
{
dtDate.Rows.Add(i.StartTime, i.Duration, i.EndTime, i.Id);
}
DateGridView.DataSource = dtDate;
DateGridView.Show();
}
public MainMenuViewer(TVprogram pr)
{
InitializeComponent();
program = pr;
SearchBox.Hide();
FavGridView.Hide();
tVshowBindingSource1.DataSource = program.tvshowList;
DateGridView.Hide();
dateBindingSource.ResetBindings(false);
DateGridView.DataSource = program.dateList;
}
protected void ClearGrids()
{
DateGridView.DataBind();
QuoteGridView.DataBind();
FilterShowingLabel.Text = "";
HeaderUpdatePanel.Update();
DetailGridView.DataBind();
QuoteDetailUpdatePanel.Update();
//UpdateButton.Visible = false;
//UpdateUpdatePanel.Update();
}
public MainMenuAdmin()
{
InitializeComponent();
program = new TVprogram();
Fill();
program.Load();
tVshowBindingSource.ResetBindings(false);
TVshowGridView.DataSource = program.tvshowList;
FillData();
DateGridView.Hide();
}
private void наЦейТижденьToolStripMenuItem_Click(object sender, EventArgs e)
{
dtDate.Clear();
foreach (Date i in program.dateList)
{
if (i.StartTime >= DateTime.Today && i.StartTime <= DateTime.Today.AddDays(7))
{
dtDate.Rows.Add(i.StartTime, i.Duration, i.EndTime, i.Id);
}
}
DateGridView.DataSource = dtDate;
DateGridView.Show();
}
private void додатиToolStripMenuItem_Click(object sender, EventArgs e)
{
var pf = new AddDate();
pf.program = program;
if (pf.ShowDialog() == DialogResult.OK)
{
program.dateList.Add(pf.Date);
FillData();
program.IsDirty = true;
DateGridView.Hide();
DateGridView.Show();
}
}
private void TVprogramStripMenuItem_Click(object sender, EventArgs e)
{
SearchBox.Hide();
TvshowGridView.Hide();
FavGridView.Hide();
DateGridView.Show();
dtDate.Clear();
foreach (Date i in program.dateList)
{
if (i.StartTime >= DateTime.Today && i.EndTime <= DateTime.Today.AddDays(1))
{
int index = program.TVshowIndexByID(i.Id);
if (index != -1)
{
dtDate.Rows.Add(i.StartTime, program.tvshowList[index].Name, program.tvshowList[index].ChanelName, i.Duration, i.EndTime);
}
}
}
}
protected void GetCustQuotes(string CustNo)
{
ClearGrids();
ds = ecommQuotes.GetCustSummary(CustNo);
if (ds.Tables.Count == 1)
{
// Fill the date grid, then the quotes for the first date
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
DateGridView.DataSource = dt;
DateGridView.DataBind();
ShowQuotesSummary(CustNo, dt.Rows[0]["QuoteDate"]);
}
else
{
ShowPageMessage("No Quotes on file for Customer " + CustNo, 2);
}
}
else
{
ShowPageMessage("Quote access problem (GetSummary). " + CustNo, 2);
}
}
private void viewToolStripMenuItem_Click(object sender, EventArgs e)
{
DateGridView.Hide();
TVshowGridView.Hide();
}
protected void GetQuotes(string CustNo, string FilterField, string FilterValue, string GridToFill)
{
try
{
// get the quote data.
string FreshQOH = "0";
if (GridToFill == "Detail")
{
FreshQOH = "1";
}
ds = SqlHelper.ExecuteDataset(connectionString, "pSOEGetQuotes",
new SqlParameter("@Organization", CustNo),
new SqlParameter("@QuoteFilterField", FilterField),
new SqlParameter("@QuoteFilterValue", FilterValue),
new SqlParameter("@FreshQOH", FreshQOH));
if (ds.Tables.Count >= 1)
{
dt = ds.Tables[1];
if (dt.Rows.Count == 0)
{
DateGridView.DataBind();
DetailGridView.DataBind();
QuoteGridView.DataBind();
FilterShowingLabel.Text = "";
}
else
{
if (GridToFill == "Header")
{
DataTable dtDates = new DataTable();
dtDates.Columns.Add("QuoteDate", typeof(DateTime));
dtDates.Columns.Add("QuoteCount", typeof(int));
int DateCtr = 0;
string Lastdate = "";
string Newdate = "";
string LastQuote = "";
string NewQuote = "";
DataRow daterow;
CustNameLabel.Text = dt.Rows[0]["CustomerName"].ToString();
Session["MasterTable"] = dt;
Lastdate = string.Format("{0:yyyy-MM-dd}", dt.Rows[0]["QuotationDate"]);
DateToGet = string.Format("{0:MM/dd/yyyy}", dt.Rows[0]["QuotationDate"]);
foreach (DataRow drow in dt.Rows)
{
Newdate = string.Format("{0:yyyy-MM-dd}", drow["QuotationDate"]);
NewQuote = drow["SessionID"].ToString();
if (Newdate != Lastdate)
{
daterow = dtDates.NewRow();
daterow["QuoteDate"] = Lastdate;
daterow["QuoteCount"] = DateCtr;
dtDates.Rows.Add(daterow);
Lastdate = Newdate;
DateCtr = 0;
}
if (NewQuote != LastQuote)
{
DateCtr++;
LastQuote = NewQuote;
}
}
daterow = dtDates.NewRow();
daterow["QuoteDate"] = Newdate;
daterow["QuoteCount"] = DateCtr;
dtDates.Rows.Add(daterow);
DateGridView.DataSource = dtDates;
DateGridView.DataBind();
FillGridView(dt);
DetailGridView.DataBind();
}
if (GridToFill == "Detail")
{
DetailGridView.DataSource = dt;
DetailGridView.DataBind();
}
//QuoteUpdatePanel.Update();
//DataView dv = new DataView(dt, "SubItem = '" + ItemNo + "'", "", DataViewRowState.CurrentRows);
//AltAvailLabel.Text = String.Format("{0:#,##0}", dv[0]["AltQOH"]);
}
}
}
catch (Exception e2)
{
ErrorLabel.Text = e2.Message + ", " + e2.ToString();
}
}
