private void button2_Click_1(object sender, EventArgs e)
{
var menNum = textBox4.Text;
var names = textBox6.Text;
var numOfcategories = int.Parse(textBox2.Text);
logic updater = new logic();
int res;
if (menNum == "" || names == "")
{
MessageBox.Show(
"Все поля должны быть заполнены",
"Ошибка",
MessageBoxButtons.OK,
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
return;
}
if (!int.TryParse(menNum, out res))
{
MessageBox.Show(
"Ввдите корректные данные",
"Ошибка",
MessageBoxButtons.OK,
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
return;
}
if (addedCategoies == (int.Parse(textBox2.Text) + 1))
{
MessageBox.Show(
"Все поля заполнены",
"Внимание",
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
return;
}
int n = dataGridView2.Rows.Add();
dataGridView2.Rows[n].Cells[0].Value = menNum;
dataGridView2.Rows[n].Cells[1].Value = names;
logic g = new logic();
var range1 = "Main Table!B" + addName + ":C" + addName;
var objectList1 = new List <object>();
objectList1.Add(menNum);
objectList1.Add(names);
g.updateRequest(range1, objectList1);
var start = dateTimePicker1.Value;
var end = dateTimePicker2.Value;
var dates = end - start;
char ch = 'G';
int x = (int)ch + dates.Days;
ch = (char)x;
int bisy = 0;
int sumRooms = 0;
int j = 0;
while (bisy >= sumRooms)
{
String range = "Data Table!G" + (numOfcategories + 3 + j) + "G" + (numOfcategories + 3 + j);
SpreadsheetsResource.ValuesResource.GetRequest request =
service.Spreadsheets.Values.Get(SpreadsheetId, range);
ValueRange response = request.Execute();
IList <IList <Object> > values = response.Values;
bisy = int.Parse(values[0][0].ToString());
String range2 = "Data Table!G" + (addName + j) + "G" + (addName + j);
SpreadsheetsResource.ValuesResource.GetRequest request2 =
service.Spreadsheets.Values.Get(SpreadsheetId, range2);
ValueRange response2 = request.Execute();
IList <IList <Object> > values2 = response2.Values;
sumRooms = int.Parse(values2[0][0].ToString());
j++;
}
Console.WriteLine(bisy.ToString(), sumRooms.ToString());
if (bisy < sumRooms)
{
bisy++;
var range3 = "Data Table!G" + addName + ch + addName;
var objectList2 = new List <object>();
for (int i = 0; i < dates.Days; i++)
{
objectList2.Add(bisy);
}
g.updateRequest(range1, objectList1);
}
else
{
if (addedCategoies == (int.Parse(textBox2.Text) + 1))
{
MessageBox.Show(
"Нет свободныз мест!",
"Внимание",
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
return;
}
}
var range5 = "Main Table!G:" + addName + ":" + ch + addName;
addName++;
}
private void button1_Click(object sender, EventArgs e)
{
GoogleCredential credential;
using (var stream = new FileStream("My First Project-2dfed0050064.json", FileMode.Open, FileAccess.Read))
{
credential = GoogleCredential.FromStream(stream).CreateScoped(Scopes);
}
service = new SheetsService(new Google.Apis.Services.BaseClientService.Initializer()
{
HttpClientInitializer = credential,
ApplicationName = ApplicationName,
});
var start = dateTimePicker1.Value;
var end = dateTimePicker2.Value;
string numOfCategories = textBox2.Text;
if (numOfCategories == "" && textBox1.Text == "")
{
MessageBox.Show(
"Все поля должны быть заполнены",
"Ошибка",
MessageBoxButtons.OK,
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
return;
}
var valueRange = new ValueRange();
logic g = new logic();
List <string> dates = new List <string>();
g.initializeDates(start, end, ref dates);
char ch = 'G';
int x = (int)ch + dates.Count;
ch = (char)x;
var range1 = "Main Table!A:" + ch;
var objectList2 = new List <object>();
objectList2.Add("Гостиница");
objectList2.Add("Кол-во чел.");
objectList2.Add("ФИО");
objectList2.Add("Номер");
objectList2.Add("Заезд");
objectList2.Add("Выезд");
foreach (var i in dates)
{
objectList2.Add(i);
}
valueRange.Values = new List <IList <object> > {
objectList2
};
var appendRequest2 = service.Spreadsheets.Values.Append(valueRange, SpreadsheetId, range1);
appendRequest2.ValueInputOption = SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum.USERENTERED;
var appendResponse2 = appendRequest2.Execute();
var range3 = "Data Table!D1" + ":" + ch;
var objectList3 = new List <object>();
objectList3.Add("Блок в отеле");
objectList3.Add("");
objectList3.Add("");
foreach (var i in dates)
{
objectList3.Add(i);
}
g.updateRequest(range3, objectList3);
var range4 = "Data Table!D" + (3 + int.Parse(numOfCategories)) + ":" + ch;
var objectList4 = new List <object>();
objectList4.Add("Фактический блок");
g.updateRequest(range4, objectList4);
var range5 = "Data Table!D" + (5 + int.Parse(numOfCategories) * 2) + ":" + ch;
var objectList5 = new List <object>();
objectList5.Add("Разница");
g.updateRequest(range5, objectList5);
}
private void button3_Click_1(object sender, EventArgs e)
{
var hotelName = textBox1.Text;
if (hotelName == "")
{
return;
}
var categoryName = textBox8.Text;
var roomCapacity = textBox7.Text;
var roomsNum = textBox5.Text;
logic updater = new logic();
int res;
if (categoryName == "" || roomCapacity == "" || roomsNum == "")
{
MessageBox.Show(
"Все поля должны быть заполнены",
"Ошибка",
MessageBoxButtons.OK,
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
return;
}
if (!int.TryParse(roomCapacity, out res) || !int.TryParse(roomsNum, out res))
{
MessageBox.Show(
"Ввдите корректные данные",
"Ошибка",
MessageBoxButtons.OK,
MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
return;
}
if (addedCategoies == (int.Parse(textBox2.Text) + 1))
{
MessageBox.Show(
"Все категории заполнены",
"Внимание",
MessageBoxButtons.OK,
MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1,
MessageBoxOptions.ServiceNotification);
return;
}
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = categoryName;
dataGridView1.Rows[n].Cells[1].Value = roomCapacity;
dataGridView1.Rows[n].Cells[2].Value = roomsNum;
allRooms += int.Parse(roomsNum);
int numOfCategories = int.Parse(textBox2.Text);
var objectList = new List <object>();
objectList.Add(categoryName);
objectList.Add(roomCapacity);
objectList.Add("");
var start = dateTimePicker1.Value;
var end = dateTimePicker2.Value;
var dates = end - start;
char ch = 'D';
int x = (int)ch + dates.Days + 4;
ch = (char)x;
for (int i = 0; i <= dates.Days + 1; i++)
{
objectList.Add(roomsNum);
}
string range = "Data Table!D" + (addedCategoies + 1) + ":" + ch + (addedCategoies + 1);
updater.updateRequest(range, objectList);
var objectList2 = new List <object>();
objectList2.Add(categoryName);
objectList2.Add(roomCapacity);
objectList2.Add("");
string range2 = "Data Table!D" + (addedCategoies + numOfCategories + 3) + ":" + ch + (addedCategoies + numOfCategories + 3);
for (int i = 0; i <= dates.Days + 1; i++)
{
objectList2.Add("0");
}
updater.updateRequest(range2, objectList2);
string range3 = "Data Table!D" + (addedCategoies + numOfCategories * 2 + 5) + ":E" + (addedCategoies + numOfCategories * 2 + 5);
var objectList3 = new List <object>();
objectList3.Add(categoryName);
objectList3.Add(roomCapacity);
updater.updateRequest(range3, objectList3);
for (int j = 0; j <= dates.Days + 1; j++)
{
char column = 'G';
x = (int)column + j;
column = (char)x;
var cell = "Data Table!" + column + (addedCategoies + numOfCategories * 2 + 5) + ":" + column;
string result = "=" + column + (addedCategoies + 1) + " - " + column + (addedCategoies + numOfCategories + 3);
var objectList4 = new List <object>();
objectList4.Add(result);
updater.updateRequest(cell, objectList4);
}
var range5 = "Main Table!A:D";
var objectList5 = new List <object>();
objectList5.Add(hotelName);
objectList5.Add("");
objectList5.Add("");
objectList5.Add(categoryName);
ValueRange valueRange = new ValueRange();
valueRange.Values = new List <IList <object> > {
objectList5
};
var appendRequest = service.Spreadsheets.Values.Append(valueRange, SpreadsheetId, range5);
appendRequest.ValueInputOption = SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum.USERENTERED;
for (int i = 0; i < int.Parse(roomsNum); i++)
{
var appendResponse = appendRequest.Execute();
}
addedCategoies++;
}