// 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()}");
}
}