private void executeSp(string path, string numArchivos)
{
ConectionDB con = new ConectionDB();
try
{
con.SqlConnect();
SqlCommand cmd = new SqlCommand();
//CONFIG OF THE COMMAND
cmd.Connection = con.GetConnection();
cmd.CommandText = Sp;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RUTA", path);
cmd.Parameters.AddWithValue("@NUMARCHIVOS", numArchivos);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
MessageBox.Show("Se ejecutó con exito.", "Ejecución correcta", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Error en la conexion o ejecucion: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.SqlCloseConection();
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request.QueryString["ID"];
ConectionDB conection = new ConectionDB();
//DrowDowList Obra
string sqlQuery = "SELECT [idObra],[nombre] FROM [dbo].[Obra]";
DataTable dt = conection.GetData(sqlQuery);
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
ListItem newItem = new ListItem(item[1].ToString(), item[0].ToString());
DD_Obra.Items.Add(newItem);
}
}
dt.Dispose();
conection.CloseDB();
//Cateria
sqlQuery = "SELECT [idCategoria],[descripcion] FROM [dbo].[Categoria]";
dt = conection.GetData(sqlQuery);
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
ListItem newItem = new ListItem(item[1].ToString(), item[0].ToString());
DD_categoria.Items.Add(newItem);
}
}
dt.Dispose();
conection.CloseDB();
}
public RoomChangeForm(int _id, MainForm _owner)
{
id = _id;
InitializeComponent();
owner = _owner;
if (id != 0)
{
ConectionDB.Connection("select type_id, price, type_of_number.type from type_of_number ", cmType);
cmType.Text = ConectionDB.ReturnResultLikeString(String.Format("select type_of_number.type from type_of_number where type_id = (select type_id from hotel_room where room_id = {0})", id));
tbNum.Text = ConectionDB.ReturnResultLikeString(String.Format("select number_of_room from hotel_room where room_id = {0}", id));
nudSleepPoint.Value = Convert.ToInt32(ConectionDB.ReturnResultLikeString(String.Format("select amount_of_sleeppoint from hotel_room where room_id = {0}", id)));
nupFloor.Value = Convert.ToInt32(ConectionDB.ReturnResultLikeString(String.Format("select floor_of_room from hotel_room where room_id = {0}", id)));
ConectionDB.ConnectionSecondCMB("select name_type from type_of_bed", cbBed);
cmType.Text = ConectionDB.ReturnResultLikeString(String.Format("select name_type from type_of_bed where type_id = (select type_of_bed_id from hotel_room where room_id = {0})", id));
}
string appPath = Path.GetDirectoryName(Application.ExecutablePath) + @"\Images\";
DataTable result = ConectionDB.ReturnResult(String.Format("select images_path from rooms_images where rooms_id={0}", id));
int y = result.Rows.Count;
foreach (DataRow item in result.Rows)
{
listOfStr.Add(item[0].ToString());
PictureBox pb = new PictureBox();
pb.Name = count.ToString();
pb.SizeMode = PictureBoxSizeMode.Zoom;
pb.Image = new Bitmap(appPath + listOfStr.Last());
flpPhotos.Controls.Add(pb);
globalPBList.Add(pb);
pb.Click += new EventHandler(pb_Click);
count++;
}
}
private void btnExport_Click(object sender, EventArgs e)
{
string fileName = txtFileName.Text;
ConectionDB con = new ConectionDB();
computerName = con.GetComputerName();
try
{
con.SqlConnect();//ABRIR CONEXION
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.GetConnection();
cmd.CommandText = "sp_generar_tmov";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@NOMBRE_DEL_EQUIPO", computerName);
cmd.Parameters.AddWithValue("@RUTA", folderPath);
cmd.Parameters.AddWithValue("@NOMBRE", fileName);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
txtFileName.Clear();
MessageBox.Show("Se ejecutó con exito.", "Ejecución correcta", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show("Error en la conexion o ejecucion: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
con.SqlCloseConection();//CERRAR CONEXION
}
private void btClose_Click(object sender, EventArgs e)
{
if (newClient)
{
if (tbSurname.Text != "" && tbFirstName.Text != "" && rtbIdentify.Text != "" && tbPhone.MaskCompleted)
{
ConectionDB.Connection(String.Format("insert into clients (surname, first_name, last_name, identify, email, phone) values('{0}','{1}','{2}','{3}','{4}','{5}')", tbSurname.Text,
tbFirstName.Text, tbLastName.Text, rtbIdentify.Text, tbEmail.Text, tbPhone.Text));
this.Close();
}
else
{
MessageBox.Show("Введены не все данные", "Ошибка", MessageBoxButtons.OK);
}
}
else
{
if (tbSurname.Text != "" && tbFirstName.Text != "" && rtbIdentify.Text != "" && tbPhone.MaskCompleted)
{
ConectionDB.Connection(String.Format("update clients set surname = '{0}', first_name ='{1}', last_name = '{2}', identify = '{3}', email = '{4}', phone = '{5}' where clients_id = {6}", tbSurname.Text,
tbFirstName.Text, tbLastName.Text, rtbIdentify.Text, tbEmail.Text, tbPhone.Text, id));
this.Close();
}
else
{
MessageBox.Show("Введены не все данные", "Ошибка", MessageBoxButtons.OK);
}
}
}
private void createPrintFile()
{
conection = new ConectionDB();
conection.SqlConnect();
try
{
cmd = new SqlCommand();
cmd.Connection = conection.GetConnection();
cmd.CommandText = "sp_generar_txt_impresion";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ruta", path);
cmd.Parameters.AddWithValue("@nombre", fileName);
cmd.Parameters.AddWithValue("@nombre_del_equipo", machineName);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
catch (Exception err)
{
MessageBox.Show("No se pudo crear el archivo de texto con los datos del comprobante, " + err.Message);
}
conection.SqlCloseConection();
}
private void ShowResult()
{
//проверка на дату
dgvMain.Columns.Clear();
queryLong = @"select * from hotel_room where state = 'Свободен' ";
if (clbType.CheckedItems.Count != 0)
{
queryLong = queryLong.Insert(queryLong.Length, " and type_id in (select type_id from type_of_number where type_of_number.type in(" + GetQueryLikeStrinOr(clbType) + "))");
}
if (clbServices.CheckedItems.Count != 0)
{
queryLong += GetQueryLikeStringAnd(clbServices);
}
if (rbTwo.Checked || rbThree.Checked || rbOne.Checked)
{
queryLong = queryLong.Insert(queryLong.Length, " and amount_of_sleeppoint = " + GetCheckRadioButton() + "");
}
queryLong += timeQuery;
ConectionDB.Connection(queryLong, dgvMain);
flpMain.Controls.Clear();
for (int i = 0; i < dgvMain.Rows.Count; i++)
{
flpMain.Controls.Add(new ResultForSearchPanelControl(Convert.ToInt32(dgvMain[0, i].Value)));
}
}
private void pb_Click(object sender, EventArgs e)
{
int idRoomImages = Convert.ToInt32(ConectionDB.ReturnResultLikeString(String.Format("select images_id from rooms_images where rooms_id = {0} and images_path = '{1}'", id, listOfStr[Convert.ToInt32((sender as PictureBox).Name)])));
int y = globalPBList.IndexOf(sender as PictureBox);
PictureForm pf = new PictureForm(idRoomImages, (RoomChangeForm)Application.OpenForms[this.Name], false, y);
pf.ShowDialog();
}
private void btDelete_Click(object sender, EventArgs e)
{
if (selectedId != 0)
{
ConectionDB.Connection(String.Format("delete from services where service_id = {0}", selectedId));
MainForm mf = (MainForm)Application.OpenForms["MainForm"];
mf.TablesUpload("services");
}
}
public void TakeQueryList()
{
foreach (AddServices items in flpServces.Controls)
{
int servId = Convert.ToInt32(ConectionDB.ReturnResultLikeString(String.Format("select service_id from services where service_name = '{0}'", items.cmServices.Text.ToString())));
ConectionDB.Connection(String.Format("insert into bill (service_id, amount, summa, main_bill_id) values ({0}, {1}, {2}, {3})", servId, items.nudAmount.Value, Convert.ToInt32(items.tbPrice.Text.ToString()), id));
}
}
private void FillFields(int id)
{
labelType.Text += ConectionDB.ReturnResultLikeString(String.Format("select type_of_number.type from type_of_number where type_id = (select type_id from hotel_room where room_id = {0})", id));
labelFloor.Text += ConectionDB.ReturnResultLikeString(String.Format("select floor_of_room from hotel_room where room_id = {0}", id));
labelNum.Text += ConectionDB.ReturnResultLikeString(String.Format("select number_of_room from hotel_room where room_id = {0}", id));
labelSleep.Text += ConectionDB.ReturnResultLikeString(String.Format("select amount_of_sleeppoint from hotel_room where room_id = {0}", id)) + ", " + ConectionDB.ReturnResultLikeString(String.Format("select name_type from type_of_bed where type_id = (select type_of_bed_id from hotel_room where room_id = {0})", id));
ConectionDB.Connection("select name_services from list_of_free_services where service_id in (select service_id from rooms_services where id in (select id from rooms_services where room_id = " + id.ToString() + "))", lbFreeServices);
ShowImages();
}
private void cmServices_DropDownClosed(object sender, EventArgs e)
{
if (isNew)
{
price = Convert.ToInt32(ConectionDB.ReturnResultLikeString(String.Format("select price_of_service from services where service_name = '{0}'", (cmServices.Text).ToString())));
tbPrice.Text = (price * nudAmount.Value).ToString();
Application.OpenForms["BillForm"].Controls["tbSum"].Text = (priceA + Convert.ToInt32(tbPrice.Text.ToString())).ToString();
}
}
private void btCreate_Click(object sender, EventArgs e)
{
if (InformationClass.queryNew != "")
{
InformationClass.clientId = Convert.ToInt32(ConectionDB.ReturnResultLikeString(InformationClass.queryNew));
}
ConectionDB.Connection(String.Format("insert into card_of_registration (clients_id, room_id, data_set, data_out, type_pay_id) values ({0}, {1}, '{2}', '{3}', {4})", InformationClass.clientId, InformationClass.roomId, InformationClass.start.ToShortDateString(), InformationClass.finish.ToShortDateString(), ConectionDB.ReturnResultLikeString(String.Format("select type_id from type_of_pay where name_type = '{0}'", cmPay.Text.ToString()))));
ConectionDB.Connection(String.Format("insert into final_bill (clients_id, number_of_days, final_summa, room_id) values ({0}, {1}, {2}, {3})", InformationClass.clientId, Convert.ToInt32(lbDays.Text), Convert.ToInt32(lbSum.Text), InformationClass.roomId));
this.Close();
}
public TypeRoom(int _id, MainForm _owner)
{
InitializeComponent();
owner = _owner;
id = _id;
if (id != 0)
{
cmType.Text = ConectionDB.ReturnResultLikeString(String.Format("select type_of_number.type from type_of_number where type_id = {0}", id));
tbPrice.Text = ConectionDB.ReturnResultLikeString(String.Format("select price from type_of_number where type_id = {0}", id));
}
}
private void rbDBClient_CheckedChanged(object sender, EventArgs e)
{
dgvClients.Enabled = true;
gbClients.Enabled = false;
gbClients.Enabled = false;
flagNewClient = false;
if (dgvClients != null)
{
ConectionDB.Connection(@"SELECT clients_id, surname as ""Фамилия"", first_name as ""Имя"", last_name as ""Отчество"", identify as ""Документ"", email as ""E-mail"", phone as ""Телефон"" from clients", dgvClients);
}
dgvClients.Columns[0].Visible = false;
}
private void btChange_Click(object sender, EventArgs e)
{
ConectionDB.Connection("Delete from rooms_services where room_id = (select room_id from hotel_room where number_of_room = '" + cbNumber.Text + "');");
for (int i = 0; i < clbFreeServices.Items.Count; i++)
{
if (clbFreeServices.GetItemChecked(i))
{
ConectionDB.Connection("Insert into rooms_services (room_id, service_id) values (" + ConectionDB.ReturnResult("select room_id from hotel_room where number_of_room = '" + cbNumber.Text + "';").Rows[0]["room_id"].ToString() + ", " + (i + 1) + ")");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
var id = Request.QueryString["ID"];
ConectionDB conection = new ConectionDB();
//Drop_list de Propietarios
string sqlQuery = "SELECT idPropietario, CONCAT(nombre,' ', apellido) AS Nombre FROM [dbo].[Propietario]";
DataTable dt = conection.GetData(sqlQuery);
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
ListItem newItem = new ListItem(item[1].ToString(), item[0].ToString());
DD_Propietario.Items.Add(newItem);
}
}
dt.Dispose();
//Drop_list de Encargados
string sqlQuery2 = "SELECT idUsuario, CONCAT(nombre,' ', apellido) AS Nombre FROM [dbo].[Usuario]";
dt = conection.GetData(sqlQuery2);
if (dt.Rows.Count > 0)
{
foreach (DataRow item1 in dt.Rows)
{
ListItem newItem1 = new ListItem(item1[1].ToString(), item1[0].ToString());
DD_Encargado.Items.Add(newItem1);
}
}
dt.Dispose();
if (!String.IsNullOrEmpty(id))
{
//Drop_list de Propietarios
sqlQuery = "SELECT * FROM [dbo].[Obra] where idObra = " + id;
dt = conection.GetData(sqlQuery);
DataRow dr = dt.Rows[0];
//llenadmos el formulario con los datos actuales
ID_obra.Value = dr[0].ToString();
DD_Encargado.SelectedValue = dr[2].ToString();
DD_Propietario.SelectedValue = dr[1].ToString();
nombre_txt.Value = dr[3].ToString();
Txt_Direccion.Value = dr[4].ToString();
dt.Dispose();
}
conection.CloseDB();
}
public HardQueryControl()
{
InitializeComponent();
ConectionDB.Connection("Select * from type_of_number;", clbType);
ConectionDB.Connection("Select * from list_of_free_services;", clbServices);
dtpStart.MinDate = DateTime.Today;
dtpStart.Value = DateTime.Today;
dtpEnd.MinDate = DateTime.Today.AddHours(24).AddDays(DateTime.Today.Hour >= 12 ? 1 : 0);
InformationClass.start = startDate;
InformationClass.finish = finishDate;
}
public ServicesForm(int _id, MainForm _owner)
{
InitializeComponent();
id = _id;
owner = _owner;
label7.Text = "Изменить";
if (id != 0)
{
tbName.Text = ConectionDB.ReturnResultLikeString(String.Format("select service_name from services where service_id = {0}", id));
tbPrice.Text = ConectionDB.ReturnResultLikeString(String.Format("select price_of_service from services where service_id = {0}", id));
}
isNew = false;
}
private void tbControlPayServices_Selecting(object sender, TabControlCancelEventArgs e)
{
if (tbControlPayServices.SelectedTab == tbControlFreeServices)
{
ConectionDB.Connection("Select * from hotel_room;", cbNumber);
ConectionDB.Connection("Select * from list_of_free_services;", clbFreeServices);
listOfString = new List <string>();
foreach (var item in clbFreeServices.Items)
{
listOfString.Add(((DataRowView)item)[1].ToString());
}
}
}
private string GetQueryLikeStringAnd(CheckedListBox _object)
{
string r = "";
List <string> listOfAnswers = new List <string>();
string finalString = "and room_id in (select room_id from rooms_services group by room_id having";
foreach (var item in _object.CheckedItems)
{
listOfAnswers.Add(((DataRowView)item)[1].ToString());
r = ConectionDB.ReturnResultLikeString("select service_id from list_of_free_services where name_services = '" + listOfAnswers.Last() + "'");
finalString += " sum(case when service_id = " + Convert.ToInt32(r) + " then 1 else 0 end)>0 and";
}
finalString = finalString.Remove(finalString.Length - 4);
finalString += ")";
return(finalString);
}
public ClientsChangeForm(int _id, MainForm _owner)
{
id = _id;
newClient = false;
owner = _owner;
InitializeComponent();
if (id != 0)
{
tbSurname.Text = ConectionDB.ReturnResultLikeString(String.Format("select surname from clients where clients_id = {0}", id));
tbFirstName.Text = ConectionDB.ReturnResultLikeString(String.Format("select first_name from clients where clients_id = {0}", id));
tbLastName.Text = ConectionDB.ReturnResultLikeString(String.Format("select last_name from clients where clients_id = {0}", id));
rtbIdentify.Text = ConectionDB.ReturnResultLikeString(String.Format("select identify from clients where clients_id = {0}", id));
tbEmail.Text = ConectionDB.ReturnResultLikeString(String.Format("select email from clients where clients_id = {0}", id));
tbPhone.Text = ConectionDB.ReturnResultLikeString(String.Format("select phone from clients where clients_id = {0}", id));
}
}
public void FillField(int id)
{
tbClient.Text = ConectionDB.ReturnResultLikeString(String.Format("select surname from clients where clients_id = (select clients_id from final_bill where final_bill_id = {0})", id)) + " " + ConectionDB.ReturnResultLikeString(String.Format("select first_name from clients where clients_id = (select clients_id from final_bill where final_bill_id = {0})", id));
tbDays.Text = ConectionDB.ReturnResultLikeString(String.Format("select number_of_days from final_bill where final_bill_id = {0}", id));
tbRoom.Text = ConectionDB.ReturnResultLikeString(String.Format("select number_of_room from hotel_room where room_id = (select room_id from final_bill where final_bill_id = {0})", id));
tbSum.Text = ConectionDB.ReturnResultLikeString(String.Format("select final_summa from final_bill where final_bill_id = {0}", id));
if (Convert.ToInt32((ConectionDB.ReturnResultLikeString(String.Format("select count(*) from bill where main_bill_id = {0}", id)))) > 0)
{
DataTable result = ConectionDB.ReturnResult(String.Format("select bill_id from bill where main_bill_id={0}", id));
foreach (DataRow item in result.Rows)
{
flpServces.Controls.Add(new AddServices(Convert.ToInt32(item[0]), false));
}
}
}
private void btNext_Click(object sender, EventArgs e)
{
if (countPanel == 0)
{
if (selectClientNewRequestControl1.isFullField())
{
hardQueryControl1.Show();
hardQueryControl1.BringToFront();
dgv = (DataGridView)hardQueryControl1.Controls["dgvMain"];
grpbx = (GroupBox)hardQueryControl1.Controls["gbSleepPoint"];
clbType = (CheckedListBox)hardQueryControl1.Controls["clbType"];
clbSer = (CheckedListBox)hardQueryControl1.Controls["clbServices"];
one = (RadioButton)hardQueryControl1.Controls["rbOne"];
two = (RadioButton)hardQueryControl1.Controls["rbTwo"];
three = (RadioButton)hardQueryControl1.Controls["rbThree"];
btPrev.Visible = true;
ConectionDB.Connection(queryLong, dgv);
countPanel++;
btNext.Text = "Показать результаты";
mainLabel.Text = "Выберите номер";
btNext.Visible = false;
if (selectClientNewRequestControl1.flagNewClient)
{
queryNewClient = String.Format("insert into clients (surname, first_name, last_name, identify, email, phone) values('{0}','{1}','{2}','{3}','{4}','{5}') RETURNING clients_id", selectClientNewRequestControl1.tbSurname.Text,
selectClientNewRequestControl1.tbFirstName.Text, selectClientNewRequestControl1.tbLastName.Text, selectClientNewRequestControl1.rtbIdentify.Text, selectClientNewRequestControl1.tbEmail.Text, selectClientNewRequestControl1.tbPhone.Text);
InformationClass.queryNew = queryNewClient;
InformationClass.surname = selectClientNewRequestControl1.tbFirstName.Text;
InformationClass.firstName = selectClientNewRequestControl1.tbSurname.Text;
}
else
{
indexClient = selectClientNewRequestControl1.idForNewForm;
}
}
else
{
MessageBox.Show("Введены не все данные", " Ошибка", MessageBoxButtons.OK);
}
}
else if (countPanel == 1)
{
mainLabel.Text = "Выберите номер";
countPanel++;
}
}
private void ShowImages()
{
string appPath = Path.GetDirectoryName(Application.ExecutablePath) + @"\Images\";
List <string> listOfStr = new List <string>();
DataTable result = ConectionDB.ReturnResult(String.Format("select images_path from rooms_images where rooms_id={0}", id));
int y = result.Rows.Count;
foreach (DataRow item in result.Rows)
{
listOfStr.Add(item[0].ToString());
PictureBox pb = new PictureBox();
pb.SizeMode = PictureBoxSizeMode.Zoom;
pb.Image = new Bitmap(appPath + listOfStr.Last());
flpPicturesBox.Controls.Add(pb);
pb.Click += new EventHandler(pb_Click);
}
}
private void btnSendProjection_Click(object sender, EventArgs e)
{
string parameter = txtProjection.Text;
if (parameter != "")
{
ConectionDB con = new ConectionDB();
try
{
con.SqlConnect();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.GetConnection();
cmd.CommandText = "sp_aplica_proyeccion";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PROYECCION", parameter);
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
txtProjection.Clear();
MessageBox.Show("Se ejecutó con exito.", "Ejecución correcta", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
double LabelX = (this.Location.X) * 0.8;
double LabelY = (this.Location.Y) * 0.2;
Label err = new Label();
err.Text = "No se pudo ejecutar correctamente: " + ex.Message;
err.Visible = true;
err.ForeColor = Color.Red;
err.Location = new Point(Convert.ToInt32(LabelX), Convert.ToInt32(LabelY));
}
con.SqlCloseConection();
}
else
{
MessageBox.Show("El campo es obligatorio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void getPrinterName()
{
conn = new ConectionDB();
try
{
conn.SqlConnect();
cmd = new SqlCommand();
cmd.Connection = conn.GetConnection();
cmd.CommandText = selectPrint;
cmd.CommandType = CommandType.Text;
SqlDataReader reader = cmd.ExecuteReader();
}
catch (Exception err)
{
MessageBox.Show("Error: " + err.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conn.SqlCloseConection();
}
private void insertPrinterName()
{
conn = new ConectionDB();
try
{
conn.SqlConnect();
cmd = new SqlCommand();
cmd.Connection = conn.GetConnection();
cmd.CommandText = "DELETE FROM " + tblName + "\nINSERT INTO " + tblName + " VALUES ('" + Printers.Text + "')";
cmd.CommandType = CommandType.Text;
var reader = cmd.ExecuteReader();
}
catch (Exception err)
{
MessageBox.Show("Error: " + err.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
conn.SqlCloseConection();
}
private void btOK_Click(object sender, EventArgs e)
{
if (tbPrice.Text != "" && tbName.Text != "")
{
if (isNew)
{
ConectionDB.Connection(String.Format("insert into services (service_name, price_of_service) values ('{0}', {1})", tbName.Text, tbPrice.Text));
}
else
{
ConectionDB.Connection(String.Format("update services set service_name = '{0}', price_of_service = {1} where service_id = {2}", tbName.Text, tbPrice.Text, id));
}
this.Close();
}
else
{
MessageBox.Show("Заполните все данные", "Ошибка");
}
}
private void ShowResult()
{
//проверка на дату
dgv.Columns.Clear();
queryLong = @"select * from hotel_room where state = 'Свободен' and ";
if (clbType.CheckedItems.Count != 0)
{
queryLong = queryLong.Insert(queryLong.Length, " and type_id in (select type_id from type_of_number where type_of_number.type in(" + GetQueryLikeStrinOr(clbType) + "))");
}
if (clbSer.CheckedItems.Count != 0)
{
queryLong += GetQueryLikeStringAnd(clbSer);
}
if (one.Checked || two.Checked || three.Checked)
{
queryLong = queryLong.Insert(queryLong.Length, " and amount_of_sleeppoint = " + GetCheckRadioButton() + "");
}
ConectionDB.Connection(queryLong, dgv);
}
