Пример #1
0
        string CheckAvail()
        {
            ArrayList list2 = new ArrayList();

            list2.Add("1");
            list2.Add("2");
            list2.Add("3");
            list2.Add("4");
            list2.Add("5");
            list2.Add("6");
            list2.Add("Amazon");
            list2.Add("Seminar Room");

            ArrayList tempList = new ArrayList();

            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            {
                for (int p = 0; p < list2.Count; p++)
                {
                    Console.WriteLine(p);

                    //  SqlDataAdapter sqlDa = new SqlDataAdapter("CheckAvailabity", con);
                    string FirstNameQuery = "select dtstart,dtend,Date from BookingDetails where Lab ='" + list2[p] + "';";
                    //  string FirstNameQuery = "select dtstart,dtend,Date from BookingDetails where Lab =" + DropDownList3.Text.Trim() +" And Date="+TextBox1.Text.Trim()+";";
                    string etime  = "select dtend from BookingDetails where Lab ='" + Labss.Text.Trim() + "';";
                    string edatey = "select Date from BookingDetails where Lab ='" + Labss.Text.Trim() + "';";

                    SqlCommand  FNAmeCom   = new SqlCommand(FirstNameQuery, con);
                    SqlCommand  edateCom   = new SqlCommand(etime, con);
                    SqlCommand  edateyCom  = new SqlCommand(edatey, con);
                    ClassName[] allRecords = null;

                    ArrayList time = new ArrayList();
                    using (var command = new SqlCommand(FirstNameQuery, con))
                    {
                        using (var reader = command.ExecuteReader())
                        {
                            var list = new List <ClassName>();
                            while (reader.Read())
                            {
                                list.Add(new ClassName("" + reader.GetTimeSpan(0), "" + reader.GetTimeSpan(1), "" + reader.GetDateTime(2)));
                            }
                            allRecords = list.ToArray();
                            reader.Close();
                        }
                    }



                    Boolean available = true;
                    for (int i = 0; i < allRecords.Length; i++)
                    {
                        ClassName cur = new ClassName(DropDownList3.Text.Trim(), DropDownList4.Text.Trim(), startddate.Text.Trim());

                        // allRecords[i].sTime.
                        if (cur.overlap(allRecords[i]))
                        {
                            available = false;
                        }
                    }
                    if (available)
                    {
                        tempList.Add(list2[p]);
                    }
                }
                string ToSend = "";
                for (int k = 0; k < tempList.Count; k++)
                {
                    ToSend += tempList[k];
                    ToSend += ", ";
                    // ToSend += "Available labs";
                }

                DataTable dtbl = new DataTable();

                con.Close();
                return(ToSend);
            }
        }