public Checkin() { data.COUNT = 0; InitializeComponent(); data.COUNT = 1; // Clear(); RACKTARRIF.IsEnabled = false; RACKADULT.IsEnabled = false; RACKCHILD.IsEnabled = false; Hotelinfo H = new Hotelinfo(); H.market(); txtextrabed.Text = "0"; EADULT.Text = "0"; ECHILD.Text = "0"; txtextrabed.IsEnabled = false; EADULT.IsEnabled = false; ECHILD.IsEnabled = false; txtmarketseg.Text = H.city; DataTable d = ch.CompanyName(); txtcompany.ItemsSource = d.DefaultView; //DataTable d1 = ch.CompanyAddress(); //companyADDRESS.ItemsSource = d1.DefaultView; //DataTable d2 = ch.Plancode(); //plancode.ItemsSource = d2.DefaultView; DataTable s = r.state(); txtstate.ItemsSource = s.DefaultView; int ID = ch.get_checkin_id(); checkinid.Text = ID.ToString(); if (RESERVSTIONCHECKIN.p == 1) { //d = RESERVSTIONCHECKIN.DD; //int a = RESERVSTIONCHECKIN.index; CHARGETARRIF.IsReadOnly = true; //rescheckinstack.Children.Remove(r1); //rescheckinstack.Children.Remove(r2); //rescheckinstack.Children.Remove(roomno); //rescheckinstack.Children.Remove(roomcategory); //reservationid.Text = "Reservation-id :" + "" + d.Rows[0]["RESERVATION_ID"].ToString(); //tb.Margin = new Thickness(10, 0, 0, 0); //tb.Width = 518; //tb.FontSize = 11; //tb.FontWeight = FontWeights.Bold; //rescheckinstack.Children.Add(tb); //int noofrooms = Convert.ToInt16(d.Rows[0]["NO_OF_ROOMS"]); //for (int I = 0; I < noofrooms; I++) //{ // if (I == 0) // { // checkinid.FontSize = 9; // checkinid.FontWeight = FontWeights.Bold; // checkinid.Text = ID.ToString(); // id.Add(ID); // } // if (I > 0) // { // checkinid.FontSize = 10; // ID = ID + 1; // checkinid.Text = " " + checkinid.Text + "," + ID; // id.Add(ID); // } //} //foreach (KeyValuePair<int, string> pair in Vacant.l) //{ // st.Add(pair.Value); // string B = pair.Value.ToString(); // tb.Text = tb.Text + " " + B + ":"; // if (!lo.Contains(pair.Key)) // { // lo.Add(pair.Key); // string A = pair.Key.ToString(); // tb.Text = tb.Text + " " + A; // } //} //txtfirstname.Text = d.Rows[a]["FIRSTNAME"].ToString(); //txtlastname.Text = d.Rows[a]["LASTNAME"].ToString(); //txtcompany.Text = d.Rows[a]["COMPANY_NAME"].ToString(); //companyADDRESS.Text = d.Rows[a]["COMPANY_ADDRESS"].ToString(); //string TIME = DateTime.Now.ToString("hh:mm:ss tt"); //DateTime DATE = Convert.ToDateTime(d.Rows[a]["ARRIVAL_DATE"]); //string date = DATE.ToShortDateString(); //arrival.Text = date + " " + TIME; //DateTime d_date = Convert.ToDateTime(d.Rows[a]["DEPARTURE_DATE"]); //DateTime D_TIME = Convert.ToDateTime(d.Rows[a]["DEPARTURE_TIME"]); //String Dtime = D_TIME.ToString("hh:mm:ss tt"); //string d_d = DATE.ToShortDateString(); //departure.Text = d_d + " " + Dtime; //ADDRESS.Text = d.Rows[a]["DOOR_NO"].ToString(); //txtcity.Text = d.Rows[a]["CITY"].ToString(); //String ST = d.Rows[a]["STATE"].ToString(); //txtstate.SelectedItem = ST; //ZIP.Text = d.Rows[a]["ZIP"].ToString(); //String CO = d.Rows[a]["COUNTRY"].ToString(); //txtcountry.SelectedItem = CO.ToLower(); //txtadult.Text = d.Rows[a]["ADULT"].ToString(); //txtchild.Text = d.Rows[a]["CHILD"].ToString(); //txtemail.Text = d.Rows[a]["EMAIL"].ToString(); //txtmobileno.Text = d.Rows[a]["MOBILE_NO"].ToString(); // roomcategory.Content = d.Rows[a]["ROOM_CATEGORY"]; //idproof.Text = d.Rows[a]["ID_TYPE"].ToString(); //txtproof.Text = d.Rows[a]["ID_DATA"].ToString(); //txtpax.Text = d.Rows[a]["PAX"].ToString(); } else { arrival.Text = Convert.ToDateTime(DateTime.Now).ToString(); //arrival.Text =Convert.ToDateTime(DateTime.Now).ToString("dd/MM/yyyy"); departure.Text = CheckinDeparture.date; roomno.Text = Vacant.roomno.ToString(); roomcategory.Text = Vacant.ROOMTYPE; DataTable dt = ch.fetch_PLANCODE(Convert.ToInt16(roomno.Text)); plancode.ItemsSource = dt.DefaultView; DataTable DT = ch.GET_COMPANY(); DataRow ROW = DT.NewRow(); ROW["COMPANY_NAME"] = "Select a Compny"; DT.Rows.InsertAt(ROW, 0); txtcompany.ItemsSource = DT.DefaultView; DataTable dc = ch.Getpaxctg(); if (dc.Rows.Count == 0) { } else { txtpax.Text = dc.Rows[0]["MAXPAX"].ToString(); } } }