private void GetDates()
{
COLTools.DB.DataBaseType = COLTools.DataBaseType.SqlServer;
COLTools.DB.ConnectionString = ConfigurationSettings.AppSettings["Astro"].ToString();
DataSet ds = COLTools.DB.RunQuerySql("select top 1 Weeklydate from Tarotpre ");
switch (System.DateTime.Today.DayOfWeek)
{
// Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(0).ToShortDateString();
case DayOfWeek.Monday :
Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(0).ToShortDateString();
Label2.Text = COLTools.Time.IST.getLocalTime().AddDays(7).ToShortDateString();
break;
case DayOfWeek.Tuesday :
Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(-1).ToShortDateString();
Label2.Text = COLTools.Time.IST.getLocalTime().AddDays(6).ToShortDateString();
break;
case DayOfWeek.Wednesday :
Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(-2).ToShortDateString();
Label2.Text = COLTools.Time.IST.getLocalTime().AddDays(5).ToShortDateString();
break;
case DayOfWeek.Thursday:
Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(-3).ToShortDateString();
Label2.Text = COLTools.Time.IST.getLocalTime().AddDays(4).ToShortDateString();
break;
case DayOfWeek.Friday:
Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(-4).ToShortDateString();
Label2.Text = COLTools.Time.IST.getLocalTime().AddDays(3).ToShortDateString();
break;
case DayOfWeek.Saturday:
Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(-5).ToShortDateString();
Label2.Text = COLTools.Time.IST.getLocalTime().AddDays(2).ToShortDateString();
break;
case DayOfWeek.Sunday:
Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(-6).ToShortDateString();
Label2.Text = COLTools.Time.IST.getLocalTime().AddDays(1).ToShortDateString();
break;
default:
Label1.Text = COLTools.Time.IST.getLocalTime().AddDays(0).ToShortDateString();
break;
}
}