<script language="c#" runat="server">   
    
        protected void Button1_Click(object sender, EventArgs e)
        {
 
        string date = Calendar1.SelectedDate.ToString();
        string date2 = Calendar2.SelectedDate.ToString();
        string strConnection = "тут строка соединения";
            SqlConnection ThisConnection = new SqlConnection(strConnection);
        ThisConnection.Open();
        SqlCommand thisCommand = ThisConnection.CreateCommand();
        thisCommand.CommandText = "SELECT DISTINCT SUM(MSP_EpmTask.TaskCost) AS Expr1 FROM MSP_EpmAssignment INNER JOIN MSP_EpmTask ON MSP_EpmAssignment.TaskUID=MSP_EpmTask.TaskUID INNER JOIN MSP_EpmResource ON MSP_EpmAssignment.ResourceUID = MSP_EpmResource.ResourceUID WHERE (MSP_EpmResource.ResourceEmailAddress = '" + SPContext.Current.Web.CurrentUser.Email + "') AND (MSP_EpmTask.TaskPercentCompleted = '100') AND (MSP_EpmAssignment.AssignmentActualStartDate >= @date) AND (MSP_EpmAssignment.AssignmentActualFinishDate <= @date2)";
        SqlParameter StartDate = new SqlParameter("@date", date);
        SqlParameter FinishDate = new SqlParameter("@date2", date2);
        thisCommand.Parameters.Add(StartDate);
        thisCommand.Parameters.Add(FinishDate);
        SqlDataReader thisReader = thisCommand.ExecuteReader();
        string res = string.Empty;
                while (thisReader.Read())
            {
                res += thisReader["Expr1"];
            }
        thisReader.Close();
        ThisConnection.Close();
        textBoxnext.Text = res;
        }
    </script>

   string curdate = DateTime.Now.ToString();
            textdate.Text = curdate;

            int curday = DateTime.Now.Day;
        

            if (curday == 17)
            {

                newdate.Text = "yes";
                string bmonth = DateTime.Now.ToString();
                string amonth = DateTime.Now.AddMonths(+1).ToString();
                datebmonth.Text = bmonth;
                dateamonth.Text = amonth;
            }

            else
            {

                newdate.Text = "no";
                string bmonth = DateTime.Now.AddMonths(-1).ToString();
                string amonth = DateTime.Now.ToString();
                datebmonth.Text = bmonth;
                dateamonth.Text = amonth;
            }
        
        
        }