protected void InvoicesTab_UNPayInvoiceButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); try { int invoiceId = Convert.ToInt32(Selected_InvoicesDataGrid_Index.Value); dataBlock.OpenConnection(); dataBlock.OpenTransaction(); dataBlock.invoiceTable.UnPayABill(invoiceId); dataBlock.CommitTransaction(); dataBlock.CloseConnection(); /* dataBlock.invoiceTable.OpenConnection(); dataBlock.invoiceTable.OpenTransaction(); dataBlock.invoiceTable.UnPayABill(invoiceId); dataBlock.invoiceTable.CommitTransaction(); dataBlock.invoiceTable.CloseConnection();*/ LoadInvoicesTable(); InvoicesDataGridUpdatePanel.Update(); InvoicesTab_ButtonsUpdateTable.Update(); } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); /*dataBlock.invoiceTable.RollbackConnection(); dataBlock.invoiceTable.CloseConnection();*/ RaiseException(ex); } }
protected void Upload_PLFFile(object Sender, EventArgs e) { SelectPLFDriver.Visible = false; FileList.Visible = false; UploadPanel.Visible = true; string connectionString = ConfigurationManager.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); try { int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]); dataBlock.OpenConnection(); dataBlock.OpenTransaction(); if (SelectPLFDriver.SelectedIndex == 0) { return; } else { List<filenameAndBytesStruct> fileUpload = new List<filenameAndBytesStruct>(); fileUpload = (List<filenameAndBytesStruct>)Session["FileUpload"]; List<int> CardIdsList = new List<int>(); CardIdsList = (List<int>)Session["CardIdsList"]; foreach (filenameAndBytesStruct curFile in fileUpload) { if (curFile.isPLF) dataBlock.AddPlfTypeData(orgId, curFile._bytes, curFile.filename, CardIdsList[SelectPLFDriver.SelectedIndex]); else dataBlock.AddData(orgId, curFile._bytes, curFile.filename); } Session["FileUpload"] = ""; } dataBlock.CommitTransaction(); dataBlock.CloseConnection(); } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); ErrorMessage.Text = "Ошибка: " + ex.Message; //show error block ErrorMessageBlock.Visible = true; } finally { SelectPLFDriver.Visible = false; FileList.Visible = false; UploadPanel.Visible = true; StatusUpdatePanel.Update(); } }
public static bool ParseDataBlocks(String OrgID, String UserName) { string connectionString = ConfigurationManager.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); PLFUnit.PLFUnitClass plfForXml = new PLFUnit.PLFUnitClass(); List<int> dataBlockIDs = new List<int>(); int filesCounter = 0; object parsedObject; try { dataBlock.OpenConnection(); dataBlock.OpenTransaction(); int userId = dataBlock.usersTable.Get_UserID_byName(UserName); int orgId = int.Parse(OrgID); dataBlockIDs = dataBlock.GetAllUnparsedDataBlockIDs(orgId); if (dataBlockIDs.Count == 0) { return true; } string output = ""; foreach (int blockId in dataBlockIDs) { dataBlock.SetDataBlockIdForParse(blockId); dataBlock.SetOrgIdForParse(orgId); string state = dataBlock.GetDataBlockState(blockId); if (state.Equals("Not parsed")) { output = HttpContext.Current.Server.MapPath("~/XML_PLF") + "\\"; parsedObject = dataBlock.ParseRecords(true, output, userId); filesCounter++; } } dataBlock.CommitTransaction(); dataBlock.CloseConnection(); return true; } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); throw ex; //return false; } }
protected void SaveDealerButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]); try { int dealerId = -1; int userId = -1; string Login = DetailedInfo_Login_TextBox.Text; string password = DetailedInfo_Password_TextBox.Text; string passwordConfirm = DetailedInfo_PasswordConfirm_TextBox.Text; string dealerName = DetailedInfo_DealerName_TextBox.Text; int countryId = Convert.ToInt32(DetailedInfo_Country_DropDown.SelectedValue); dataBlock.OpenConnection(); dataBlock.OpenTransaction(); int curUserId = dataBlock.usersTable.Get_UserID_byName(Page.User.Identity.Name); int orgTypeId = dataBlock.organizationTable.GetOrgTypeId(orgId); switch (NewOrEditUser_hdnField.Value) { case "new": { int neworgTypeId; if (orgTypeId == dataBlock.organizationTable.DealerTypeId) neworgTypeId = dataBlock.organizationTable.SubdealerTypeId; else neworgTypeId = dataBlock.organizationTable.DealerTypeId; dealerId = dataBlock.organizationTable.AddNewOrganization(dealerName, neworgTypeId, countryId, 1, orgId); UserFromTable newUser = new UserFromTable(Login, password, "", "", DateTime.Now, ""); userId = dataBlock.usersTable.AddNewUser(newUser, dataBlock.usersTable.DealerUserTypeId, 1, dealerId, 0); } break; case "edit": { dealerId = Convert.ToInt32(Selected_DealersDataGrid_Index.Value); dataBlock.organizationTable.SetOrganizationName(dealerName, dealerId); dataBlock.organizationTable.SetOrgCountryAndRegion(dealerId, countryId, 1);//тут регион ставится в 1, если надо будет регать где-то регион - поправить! userId = dataBlock.usersTable.Get_AllUsersId(dealerId, dataBlock.usersTable.DealerUserTypeId)[0]; int userRoleId = dataBlock.usersTable.GetUserRoleId(userId); string OldPass = dataBlock.usersTable.Get_UserPassword(userId); string oldName = dataBlock.usersTable.Get_UserName(userId); UserFromTable newUser = new UserFromTable(Login, password, "", "", DateTime.Now, ""); dataBlock.usersTable.EditUser(OldPass, oldName, newUser, dataBlock.usersTable.DealerUserTypeId, userRoleId, dealerId, curUserId); } break; } if (userId < 0) throw new Exception("Не выбран пользователь или произошла ошибка редактирования!"); SaveAdditionalInformation(dealerId, dataBlock); dataBlock.CommitTransaction(); dataBlock.CloseConnection(); } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); RaiseException(ex); } finally { DetailedInformationPanel.Enabled = false; EditDealer(false); LoadDealersTable(); //DealersTabContainer.ActiveTab = DealersTab; Сделать переключение вкладок! UpdatePanel1.Update(); } }
protected void Parse_Click(object Sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); PLFUnit.PLFUnitClass plfForXml = new PLFUnit.PLFUnitClass(); List<int> dataBlockIDs = new List<int>(); int cardType = 0; int filesCounter = 0; object parsedObject; try { dataBlock.OpenConnection(); dataBlock.OpenTransaction(); int userId = dataBlock.usersTable.Get_UserID_byName(User.Identity.Name); int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]); dataBlockIDs = dataBlock.GetAllUnparsedDataBlockIDs(orgId); if (dataBlockIDs.Count == 0) throw new Exception("Отсутствуют данные для разбора."); string output = ""; foreach (int blockId in dataBlockIDs) { dataBlock.SetDataBlockIdForParse(blockId); dataBlock.SetOrgIdForParse(orgId); //dataBlock = new DataBlock(connectionString, blockId, ConfigurationManager.AppSettings["language"], orgId); if (dataBlock.GetDataBlockState(blockId) == "Not parsed") { output = Server.MapPath("~/XML_PLF") + "\\"; parsedObject = dataBlock.ParseRecords(true, output, userId); filesCounter++; } else continue; } dataBlock.CommitTransaction(); dataBlock.CloseConnection(); LoadAllLists(); if (filesCounter > 0) Status.Text = "Файлы разобраны успешно! Разобрано " + filesCounter.ToString() + " файлов."; else Status.Text = "Не разобрано ни одного файла."; } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); LoadAllLists(); Status.Text = "Ошибка: " + ex.Message; } finally { StatusUpdatePanel.Update(); ModalPopupExtender1.Hide(); } }
public void LoadAllInfo() { Console.WriteLine("Conerting starts"); DateTime startLoadTime = DateTime.Now; PLFUnit.PLFUnitClass plf; CARS cars = new CARS(fb_con); cars.LoadAllCars(); DEPARTMENTS depar = new DEPARTMENTS(fb_con); depar.LoadAllDepartments(); WORKERS workers = new WORKERS(fb_con); workers.LoadAllWorkers(); DEVICES devices = new DEVICES(fb_con); devices.LoadAllDevices(); READCYCLE readcycle = new READCYCLE(fb_con); readcycle.LoadAllReadCycles(); DataBlock datablock = new DataBlock(connectionStringMysql, currentLanguage); try { List<KeyValuePair<int, int>> orgOldNewIds = new List<KeyValuePair<int, int>>(); List<KeyValuePair<int, int>> workOldNewIds = new List<KeyValuePair<int, int>>(); List<KeyValuePair<int, int>> carsOldNewIds = new List<KeyValuePair<int, int>>(); List<KeyValuePair<READCYCLE.readcycle, int>> readCycleAndorgIdList = new List<KeyValuePair<READCYCLE.readcycle, int>>(); List<int> allIds = new List<int>(); int newDeviceId = -1; int userInfoId; KeyValuePair<int, int> tempOldNewIds; List<int> addedWorkers = new List<int>(); datablock.OpenConnection(); datablock.OpenTransaction(); //Создание организация, работников и ТС foreach (DEPARTMENTS.department department in depar.departments) { addedWorkers = new List<int>(); int orgId = datablock.organizationTable.AddNewOrganization(department.DEPARTMENT, 1, 1, 1); tempOldNewIds = new KeyValuePair<int, int>(department.ID, orgId); orgOldNewIds.Add(tempOldNewIds); int carId = -1; #region "cars" IEnumerable<CARS.car> carsList = from car in cars.carsArray where car.DEPARTMENTID == department.ID select car; foreach (CARS.car car in carsList) { IEnumerable<int> scoreQuery = from devId in readcycle.cycles where devId.CARID == car.ID select devId.DEVICEID; allIds = scoreQuery.ToList(); if (allIds.Count > 0) { IEnumerable<DEVICES.device> oneDevice = from devId in devices.devices where devId.ID == allIds[0] select devId; if (oneDevice.ToList().Count > 0) { DEVICES.device NewDevice = oneDevice.ToList()[0]; newDeviceId = datablock.deviceTable.AddNewDevice(1, NewDevice.DEVICE, NewDevice.VERSION, DateTime.Now, 1, 23442324); } else newDeviceId = datablock.deviceTable.AddNewDevice(1, "UndefinedDevice", "UndefinedVersion", DateTime.Now, 1, 23442324); } else newDeviceId = datablock.deviceTable.AddNewDevice(1, "UndefinedDevice", "UndefinedVersion", DateTime.Now, 1, 23442324); if (car.DEPARTMENTID == department.ID) { int cardId = datablock.cardsTable.CreateNewCard(car.REGNUMBER, "Unknown", datablock.cardsTable.vehicleCardTypeId, orgId, 0, "Created from FIREBIRD database", 0, 1); carId = datablock.vehiclesTables.AddNewVehicle(car.REGNUMBER, car.CARMODEL, "Unknown", 1, newDeviceId, cardId, DateTime.Now, 1); tempOldNewIds = new KeyValuePair<int, int>(car.ID, carId); carsOldNewIds.Add(tempOldNewIds); } } #endregion #region "workers" IEnumerable<WORKERS.worker> workersList = from worker in workers.workers where worker.DEPARTMENTID == department.ID select worker; foreach (WORKERS.worker workerForAdd in workersList) { int newWId = datablock.cardsTable.CreateNewCard(workerForAdd.FIRSTNAME + " " + workerForAdd.SURNAME, workerForAdd.WORKERINTID.ToString(), datablock.cardsTable.driversCardTypeId, orgId, 0, "Created from firebird", 0, 1); /*userInfoId = datablock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_Patronimic); datablock.usersTable.EditUserInfo(newWId, userInfoId, workerForAdd.MIDDLENAME); userInfoId = datablock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_Name); datablock.usersTable.EditUserInfo(newWId, userInfoId, workerForAdd.FIRSTNAME); userInfoId = datablock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_Surname); datablock.usersTable.EditUserInfo(newWId, userInfoId, workerForAdd.SURNAME); userInfoId = datablock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_Birthday); datablock.usersTable.EditUserInfo(newWId, userInfoId, workerForAdd.BIRTHDAY.ToShortDateString()); userInfoId = datablock.usersTable.GetUserInfoNameId(DataBaseReference.UserInfo_DriversCertificate); datablock.usersTable.EditUserInfo(newWId, userInfoId, workerForAdd.LICENCE);*/ addedWorkers.Add(workerForAdd.ID); tempOldNewIds = new KeyValuePair<int, int>(workerForAdd.ID, newWId); workOldNewIds.Add(tempOldNewIds); } #endregion #region "set orgId to READCYCLES" if(addedWorkers.Count>0) for(int i=0;i<readcycle.cycles.Count;i++) { if(addedWorkers.Contains(readcycle.cycles[i].WORKER1ID) || addedWorkers.Contains(readcycle.cycles[i].WORKER2ID)) { KeyValuePair<READCYCLE.readcycle, int> readCycleAndorgId = new KeyValuePair<READCYCLE.readcycle, int>(readcycle.cycles[i], orgId); readCycleAndorgIdList.Add(readCycleAndorgId); } } #endregion } Console.WriteLine("Added workers, departmens, cars"); if (readCycleAndorgIdList.Count != readcycle.cycles.Count) { if (false) //база фигово связана throw new Exception("Куда-то пропала часть инфы"); } //Загрузка файлов ПЛФ в ранее созданные организации. foreach (KeyValuePair<READCYCLE.readcycle, int> readedcycle in readCycleAndorgIdList) { SQLDB sqlDb = datablock.sqlDb; SQLDB_Records sqlDB_rec = new SQLDB_Records(connectionStringMysql, sqlDb.GETMYSQLCONNECTION()); ReflectObjectToTableClass reflectedItemsList; byte[] bytes = Guid.NewGuid().ToByteArray(); int orgId = readedcycle.Value; Type type = null; object myParseObject = new object(); plf = new PLFUnitClass(); plf = LoadLogBook(readedcycle.Key); plf.cardType = 2; IEnumerable<string> selCar = from car in cars.carsArray where car.ID == readedcycle.Key.CARID select car.REGNUMBER; if(selCar.ToList().Count>0) plf.VEHICLE = selCar.ToList()[0]; IEnumerable<string> selDeviceName = from dev in devices.devices where dev.ID == readedcycle.Key.DEVICEID select dev.DEVICE; if (selDeviceName.ToList().Count > 0) plf.ID_DEVICE = selDeviceName.ToList()[0]; int driverId = -1; foreach (KeyValuePair<int, int> oldNew in workOldNewIds) { if (oldNew.Key == readedcycle.Key.WORKER1ID) driverId = oldNew.Value; } int dataBlockId = datablock.AddPlfTypeData(orgId, bytes, "AutoGenerated " + plf.VEHICLE + " " + plf.START_PERIOD.ToString() + " - " + plf.END_PERIOD.ToString(), driverId); DataRecords dataRecord = new DataRecords(connectionString, dataBlockId, currentLanguage, sqlDb); //////////////////////устанавливаем PLF карту нужного водителя. Незнаю почему именно здесь, но так получилось. int plfDriversCardType = sqlDB_rec.Get_DataBlockCardType(dataBlockId); sqlDb.SetDataBlock_CardId(dataBlockId, plfDriversCardType); // sqlDB.OpenConnection(); int cardTypeParamId = sqlDb.AddParam("cardType", 0, 255); //sqlDB.OpenConnection(); sqlDb.DeleteDataRecord(dataBlockId, cardTypeParamId); // sqlDB.CloseConnection(); ////////////////////// type = plf.GetType(); myParseObject = plf; //sqlDB.OpenConnection(); SetParseBDate(sqlDb, dataBlockId); //sqlDB.CloseConnection(); List<ReflectObjectToTableClass> allRecordsToAdd = new List<ReflectObjectToTableClass>(); foreach (PropertyInfo pi in type.GetProperties(BindingFlags.Public | BindingFlags.Instance)) { reflectedItemsList = new ReflectObjectToTableClass(); string fieldName = pi.Name; object field2 = pi.GetValue(myParseObject, null); if (field2 != null) { reflectedItemsList.ReflectObjectToTable(fieldName, field2);//Не удалять! allRecordsToAdd.Add(AddRecords(reflectedItemsList, sqlDb));//не удалять } } foreach (ReflectObjectToTableClass recordList in allRecordsToAdd) { dataRecord.AddDataArray(recordList.reflectedItemsList); } //sqlDB.OpenConnection(); SetParseEDate(sqlDb,dataBlockId); sqlDb.SetDataBlockState(dataBlockId, 2); int dataBlockParseRecords = sqlDb.SetDataBlockParseRecords(dataBlockId); Console.WriteLine("" + dataBlockParseRecords.ToString()+" records added"); } Console.WriteLine("\n\r" + "Время начала импорта " + startLoadTime.ToShortDateString() + " " + startLoadTime.ToShortTimeString()); Console.WriteLine("\n\r" + "Время окончания импорта " + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString()); //throw new Exception(); datablock.CommitTransaction(); datablock.CloseConnection(); } catch (Exception ex) { datablock.RollbackConnection(); datablock.CloseConnection(); Console.WriteLine(ex.Message); } }
protected void SaveAccountButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]); try { int accountId = -1; int userId = -1; string Login = DetailedInfo_Login_TextBox.Text; string password = DetailedInfo_Password_TextBox.Text; string passwordConfirm = DetailedInfo_PasswordConfirm_TextBox.Text; string accountName = DetailedInfo_AccountName_TextBox.Text; int accountType = Convert.ToInt32(AccountTypeDropDown.SelectedValue); int countryId = Convert.ToInt32(DetailedInfo_Country_DropDown.SelectedValue); dataBlock.OpenConnection(); dataBlock.OpenTransaction(); int curUserId = dataBlock.usersTable.Get_UserID_byName(Page.User.Identity.Name); int orgTypeId = dataBlock.organizationTable.GetOrgTypeId(orgId); switch (NewOrEditUser_hdnField.Value) { case "new": { accountId = dataBlock.organizationTable.AddNewOrganization(accountName, accountType, countryId, 1, orgId); UserFromTable newUser = new UserFromTable(Login, password, "", "", DateTime.Now, ""); if (accountType != dataBlock.organizationTable.ClientTypeId) userId = dataBlock.usersTable.AddNewUser(newUser, dataBlock.usersTable.DealerUserTypeId, 1, accountId, 0); else { userId = dataBlock.usersTable.AddNewUser(newUser, dataBlock.usersTable.AdministratorUserTypeId, 1, accountId, curUserId); dataBlock.usersTable.AddUserInfoValue(userId, DataBaseReference.UserInfo_DealerId, orgId.ToString()); } } break; case "edit": { accountId = Convert.ToInt32(Selected_AccountsDataGrid_Index.Value); string oldName = dataBlock.organizationTable.GetOrganizationName(accountId); //dataBlock.organizationTable.SetOrganizationName(accountName, accountId); //dataBlock.organizationTable.SetOrgCountryAndRegion(accountId, countryId, 1);//тут регион ставится в 1, если надо будет регать где-то регион - поправить! dataBlock.organizationTable.EditOrganization(oldName, accountName, accountType, countryId, 1); /*userId = dataBlock.usersTable.Get_AllUsersId(accountId, dataBlock.usersTable.AccountUserTypeId)[0]; int userRoleId = dataBlock.usersTable.GetUserRoleId(userId); string OldPass = dataBlock.usersTable.Get_UserPassword(userId); string oldName = dataBlock.usersTable.Get_UserName(userId); UserFromTable newUser = new UserFromTable(Login, password, "", "", DateTime.Now, ""); dataBlock.usersTable.EditUser(OldPass, oldName, newUser, dataBlock.usersTable.AccountUserTypeId, userRoleId, accountId, curUserId);*/ } break; } if (accountId < 0) throw new Exception("Не выбран аккаунт или произошла ошибка редактирования!"); SaveAdditionalInformation(accountId, dataBlock); dataBlock.CommitTransaction(); dataBlock.CloseConnection(); } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); RaiseException(ex); } finally { DetailedInformationPanel.Enabled = false; EditAccount(false); LoadAccountsTable(); //AccountsTabContainer.ActiveTab = AccountsTab; Сделать переключение вкладок! DetailedInformationUpdatePanel.Update(); //this.Parent. // ((UpdatePanel)Page.FindControl("AccountsTreeUpdatePanel")).Update(); } }
protected void SaveClientButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]); try { int newClientId = -1; int userId = -1; string clientName = DetailedInfo_ClientName_TextBox.Text; int countryId = Convert.ToInt32(DetailedInfo_Country_DropDown.SelectedValue); dataBlock.OpenConnection(); dataBlock.OpenTransaction(); int curUserId = dataBlock.usersTable.Get_UserID_byName(Page.User.Identity.Name); int orgTypeId = dataBlock.organizationTable.GetOrgTypeId(orgId); switch (NewOrEditUser_hdnField.Value) { case "new": { int neworgTypeId = dataBlock.organizationTable.ClientTypeId; newClientId = dataBlock.organizationTable.AddNewOrganization(clientName, neworgTypeId, countryId, 1, orgId); if (clientName.Length > 9) clientName = clientName.Substring(0, 9); UserFromTable newUser = new UserFromTable(clientName, "123", "", "", DateTime.Now, ""); userId = dataBlock.usersTable.AddNewUser(newUser, dataBlock.usersTable.AdministratorUserTypeId, 1, newClientId, 0); dataBlock.usersTable.AddUserInfoValue(userId, DataBaseReference.UserInfo_DealerId, orgId.ToString()); } break; case "edit": { newClientId = Convert.ToInt32(Selected_ClientsDataGrid_Index.Value); dataBlock.organizationTable.SetOrganizationName(clientName, newClientId); dataBlock.organizationTable.SetOrgCountryAndRegion(newClientId, countryId, 1);//тут регион ставится в 1, если надо будет регать где-то регион - поправить! } break; } if (userId < 0) throw new Exception("Не выбран пользователь или произошла ошибка редактирования!"); SaveAdditionalInformation(newClientId, dataBlock); dataBlock.CommitTransaction(); dataBlock.CloseConnection(); } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); RaiseException(ex); } finally { DetailedInformationPanel.Enabled = false; EditClient(false); LoadClientsTable(); //DealersTabContainer.ActiveTab = DealersTab; Сделать переключение вкладок! UpdatePanel1.Update(); } }
protected void SaveUserButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); try { int userId = -1; int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]); string Login = DetailedInfo_Login_TextBox.Text; string password = DetailedInfo_Password_TextBox.Text; string passwordConfirm = DetailedInfo_PasswordConfirm_TextBox.Text; int UserRoleId = Convert.ToInt32(DetailedInfo_UserRole_DropDown.SelectedValue); int userTypeId = Convert.ToInt32(DetailedInfo_UserType_DropDown.SelectedValue); dataBlock.OpenConnection(); dataBlock.OpenTransaction(); int curUserId = dataBlock.usersTable.Get_UserID_byName(Page.User.Identity.Name); switch (NewOrEditUser_hdnField.Value) { case "new": { UserFromTable newUser = new UserFromTable(Login, password, "", "", DateTime.Now, ""); userId = dataBlock.usersTable.AddNewUser(newUser, userTypeId, UserRoleId, orgId, curUserId); } break; case "edit": { userId = Convert.ToInt32(Selected_UsersDataGrid_Index.Value); string OldPass = dataBlock.usersTable.Get_UserPassword(userId); string oldName = dataBlock.usersTable.Get_UserName(userId); UserFromTable newUser = new UserFromTable(Login, password, "", "", DateTime.Now, ""); dataBlock.usersTable.EditUser(OldPass, oldName, newUser, userTypeId, UserRoleId, orgId, curUserId); } break; } if (userId < 0) throw new Exception("Не выбран пользователь!"); SaveAdditionalInformation(userId, dataBlock); dataBlock.CommitTransaction(); dataBlock.CloseConnection(); } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); RaiseException(ex); } finally { DetailedInformationPanel.Enabled = false; EditUser(false); LoadUsersTable(); //UsersTabContainer.ActiveTab = UsersTab; UpdatePanel1.Update(); } }
protected void ReportsTab_AddReportButton_Click(object sender, EventArgs e) { string connectionString = ConfigurationSettings.AppSettings["fleetnetbaseConnectionString"]; DataBlock dataBlock = new DataBlock(connectionString, ConfigurationManager.AppSettings["language"]); try { dataBlock.OpenConnection(); dataBlock.OpenTransaction(); int curUserId = dataBlock.usersTable.Get_UserID_byName(Page.User.Identity.Name); int orgId = Convert.ToInt32(Session["CURRENT_ORG_ID"]); int reportId = Convert.ToInt32(Selected_ReportsDataGrid_Index.Value); dataBlock.reportsTable.AddOrSetReportUserOrg_ActivateReportForORG(reportId, orgId, curUserId); string billName = @"Invoice for report """ + dataBlock.reportsTable.GetReportName(reportId) + @""""; ///Выставляем счет, когда добавляем отчет. Потом по-любому все убрать!!!! dataBlock.invoiceTable.AddInvoice(dataBlock.invoiceTable.InvoiceType_addReportInvoice, dataBlock.invoiceTable.Status_NotPaid, orgId, billName, DateTime.Now, DateTime.Now.AddDays(7), new DateTime()); ///////////////////////////////////////////////////// dataBlock.CommitTransaction(); dataBlock.CloseConnection(); } catch (Exception ex) { dataBlock.RollbackConnection(); dataBlock.CloseConnection(); RaiseException(ex); } LoadReportsTable(); ReportsTab_AddReportButton.Enabled = false; AccessPanel1.Enabled = false; ReportsUpdatePanel.Update(); }