private void AddButton_Click(object sender, EventArgs e) { try { ConvertData(); EstateObjects.Insert(SqlConnection, Status, OwnerId, Price, Address, District, Description, RealtyTypes, TradeTypes, Area, Rooms, LandDescription, LandArea); MessageBox.Show("Запись добавлена"); this.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private static void GetCellValue(Excel.Worksheet sheet, SqlConnection sqlConnection) { int lastRow = sheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row; // Последняя заполненная строка string[,] mas = new string[lastRow, 4]; // Выделяем память под массив строк mas = ArrRange(2, 1, lastRow, 12, sheet); // Получаем данные с листа for (int l = 0; l < lastRow - 1; l++) // Заполняем массив { int statusId = Convert.ToInt32(mas[l, 0]); int ownerId = Convert.ToInt32(mas[l, 1]); float price = (float)Convert.ToDouble(mas[l, 2]); string addres = mas[l, 3]; int district = Convert.ToInt32(mas[l, 4]); string description = mas[l, 5]; int realtytype = Convert.ToInt32(mas[l, 6]); int tradetype = Convert.ToInt32(mas[l, 7]); float area = (float)Convert.ToDouble(mas[l, 8]); byte rooms = Convert.ToByte(mas[l, 9]); string landdescription = mas[l, 10]; float landarea = (float)Convert.ToDouble(mas[l, 11]); try { if (realtytype == 3) { EstateObjects.Insert(sqlConnection, statusId, ownerId, price, addres, district, description, realtytype, tradetype, area, rooms, landdescription, landarea); } if (realtytype == 1) { EstateObjects.Insert(sqlConnection, statusId, ownerId, price, addres, district, description, realtytype, tradetype, area, rooms); } if (realtytype == 2) { EstateObjects.Insert(sqlConnection, statusId, ownerId, price, addres, district, description, realtytype, tradetype, area); } } catch (Exception e) { MessageBox.Show(e.ToString()); } } }