// Nalezení záznamu pro výmaz nebo změnu z VERSION_COMPANY public VERSION_COMPANY GetCompanyForDeletion(int idCompany) { try { using (OracleConnectionString accessToDB = new OracleConnectionString()) { return(accessToDB.VERSION_COMPANY.Where(x => x.VER_COMPANY_ID == idCompany).SingleOrDefault()); } } catch (Exception ex) { VERSION_COMPANY error = new VERSION_COMPANY(); error.VER_COMPANY_DESC = ex.Message.ToString(); return(error); } }
// Aktualizace záznamu v VERSION_COMPANY public string ChangeCompany(VERSION_COMPANY companyForChange) { try { using (OracleConnectionString accessToDB = new OracleConnectionString()) { accessToDB.Entry(companyForChange).State = System.Data.Entity.EntityState.Modified; accessToDB.SaveChanges(); return(result = "Požadavek byl proveden"); } } catch (Exception ex) { return(result = $"Požadavek NEBYL proveden.Popis chyby:\n\n { ex.Message.ToString()} "); } }
// Přidání záznamu do VERSION_COMPANY public string AddCompany(VERSION_COMPANY companyToDB) { companyToDB.VER_COMPANY_ID = GetNextIdNumberForDbTable("VERSION_COMPANY", "VER_COMPANY_ID"); if (companyToDB.VER_COMPANY_ID == 5555) { return(result = "Metoda \"GetLastIdNumberFromVersionCompany\" vrátila chybu"); } try { using (OracleConnectionString accessToDB = new OracleConnectionString()) { accessToDB.VERSION_COMPANY.Add(companyToDB); accessToDB.SaveChanges(); return(result = "Požadavek byl proveden"); } } catch (Exception ex) { return(result = $"Požadavek NEBYL proveden. Popis chyby:\n {ex.Message.ToString()}"); } }