private void MiCalenderView_Click(object sender, EventArgs e)
{
frmCalenderView Picker = new frmCalenderView();
Picker.Show();
}
public frmCalendarDueDate(frmCalenderView calenderView)
{
this.calenderView = calenderView;
//lblDue.Text = calenderView.dueDate;
InitializeComponent();
lblDue.Text = "Tasks due on " + calenderView.mcCalenderView.SelectionRange.End.Month + "/" + calenderView.mcCalenderView.SelectionRange.Start.Day + "/" + calenderView.mcCalenderView.SelectionRange.Start.Year;
string connectionString;
SqlConnection cnn;
SqlCommand command;
SqlDataReader dataReader;
string sql, output = "";
connectionString = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=GroupProject;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";
cnn = new SqlConnection(connectionString);
cnn.Open();
sql = "Select Task from Calendar where DueDate = ('" + calenderView.mcCalenderView.SelectionRange.End.Month + "/" + calenderView.mcCalenderView.SelectionRange.End.Day + "/" + calenderView.mcCalenderView.SelectionRange.End.Year +
"')";
command = new SqlCommand(sql, cnn);
dataReader = command.ExecuteReader();
int count = 0;
while (dataReader.Read())
{
if (count == 0)
{
output = output + dataReader.GetValue(0) + Environment.NewLine;
//tbAdded.Text = Convert.ToString(dataReader.GetValue(0));
//tbAdded.AppendText(Environment.NewLine);
count++;
}
else if (count >= 1)
{
output = output + Environment.NewLine + dataReader.GetValue(0) + Environment.NewLine;
//tbAdded.AppendText(Environment.NewLine);
//tbAdded.AppendText(Convert.ToString(dataReader.GetValue(0)));
//tbAdded.AppendText(Environment.NewLine);
count++;
}
}
if (count <= 0)
{
tbDue.Text = "NO TASKS DUE";
}
else
{
tbDue.Text = output;
}
dataReader.Close();
command.Dispose();
cnn.Close();
}