private void btnNotifPDC_Click(object sender, EventArgs e)
{
using (SqlConnection con = new SqlConnection(global.connectString()))
{
con.Open();
var mos = DateTime.Today.Month;
var yr = DateTime.Today.Year;
var day = DateTime.Today.Day;
DateTime dtNowFrom;
DateTime dtNowTo;
if (day <= 15)
{
dtNowFrom = new DateTime(yr, mos, 09);
dtNowTo = new DateTime(yr, mos, 15);
}
else
{
dtNowFrom = new DateTime(yr, mos, 25);
dtNowTo = new DateTime(yr, mos, DateTime.DaysInMonth(yr, mos));
}
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "sp_GetChequeDateDueToday";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ChequeDateFrom", dtNowFrom);
cmd.Parameters.AddWithValue("@ChequeDateTo", dtNowTo);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
PDCManagement frm = new PDCManagement();
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(PDCManagement))
{
form.Activate();
frm = (PDCManagement)Application.OpenForms["PDCManagement"];
frm.dataGridView1.DataSource = dt;
frm.str = "";
frm.str = "SELECT * FROM vw_PDCManagement WHERE ORNumber is NULL and ChequeDate between '" + dtNowFrom.ToShortDateString() + "' and '" + dtNowTo.ToShortDateString() + "'";
return;
}
}
frm.str = "";
frm.str = "SELECT * FROM vw_PDCManagement WHERE ORNumber is NULL and ChequeDate between '" + dtNowFrom.ToShortDateString() + "' and '" + dtNowTo.ToShortDateString() + "'";
frm.Show();
frm.MdiParent = this;
frm.dataGridView1.DataSource = dt;
}
}
private void panelHeader_Click(object sender, EventArgs e)
{
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(PDCManagement))
{
form.Activate();
return;
}
}
PDCManagement frm = new PDCManagement();
frm.Show();
frm.MdiParent = this;
}
private void button33_Click(object sender, EventArgs e)
{
panelPDCManagement.Visible = false;
//controls
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(PDCManagement))
{
form.Activate();
return;
}
}
PDCManagement frm = new PDCManagement();
frm.Show();
frm.MdiParent = this;
}
