//Cambiare questo switch in base al reale nome della tabella nel database
public void SavePreventive(tPreventiveDetails preventive, EnumUseful.typeOfDatabaseOperation typeOfDatabaseOperation)
{
switch (typeOfDatabaseOperation)
{
case EnumUseful.typeOfDatabaseOperation.EDIT:
tPreventiveDetails PreventiveToEdit = dbEntity.tPreventiveDetails.FirstOrDefault(
x => x.IdPreventivo == preventive.IdPreventivo
);
if (PreventiveToEdit != null)
{
PreventiveToEdit.IdCliente = preventive.IdCliente;
PreventiveToEdit.NumeroPreventivo = preventive.NumeroPreventivo;
PreventiveToEdit.Riferimento = preventive.Riferimento;
PreventiveToEdit.Allegati = preventive.Allegati;
PreventiveToEdit.Oggetto = preventive.Oggetto;
PreventiveToEdit.Attenzione = preventive.Attenzione;
PreventiveToEdit.Durata = preventive.Durata;
PreventiveToEdit.Data_ = preventive.Data_;
PreventiveToEdit.Confermato = preventive.Confermato;
PreventiveToEdit.Operatore = preventive.Operatore;
PreventiveToEdit.AddebitoTransporto = preventive.AddebitoTransporto;
PreventiveToEdit.Sconto = preventive.Sconto;
PreventiveToEdit.Progetto = preventive.Progetto;
PreventiveToEdit.Variazione = preventive.Variazione;
PreventiveToEdit.Totale = preventive.Totale;
PreventiveToEdit.Pagamento = preventive.Pagamento;
PreventiveToEdit.Consegna = preventive.Consegna;
PreventiveToEdit.NotaApertura = preventive.NotaApertura;
PreventiveToEdit.NotaChiusura = preventive.NotaChiusura;
PreventiveToEdit.NoteAndamaneto = preventive.NoteAndamaneto;
PreventiveToEdit.DataInizioLavoro = preventive.DataInizioLavoro;
PreventiveToEdit.NumeroCommisione = preventive.NumeroCommisione;
PreventiveToEdit.Referenza = preventive.Referenza;
PreventiveToEdit.Listino = preventive.Listino;
}
break;
case EnumUseful.typeOfDatabaseOperation.CREATE:
if (preventive != null)
{
dbEntity.tPreventiveDetails.Add(preventive);
}
break;
}
dbEntity.SaveChanges();
}
public void SaveCompany(tDitte Company, EnumUseful.typeOfDatabaseOperation typeOfDatabaseOperation)
{
switch (typeOfDatabaseOperation)
{
case EnumUseful.typeOfDatabaseOperation.EDIT:
tDitte CompanyToEdit = dbEntity.tDitte.FirstOrDefault(
x => x.IdDitta == Company.IdDitta
);
if (CompanyToEdit != null)
{
CompanyToEdit.IdDitta = Company.IdDitta;
CompanyToEdit.NomeDitta = Company.NomeDitta;
CompanyToEdit.RagioneSocialeDitta = Company.RagioneSocialeDitta;
CompanyToEdit.IndirizzoDitta = Company.IndirizzoDitta;
CompanyToEdit.CapDitta = Company.CapDitta;
CompanyToEdit.CittaDitta = Company.CittaDitta;
CompanyToEdit.ProvinciaDitta = Company.ProvinciaDitta;
CompanyToEdit.TelefonoDitta = Company.TelefonoDitta;
CompanyToEdit.FaxDitta = Company.FaxDitta;
CompanyToEdit.UrlDitta = Company.UrlDitta;
CompanyToEdit.EmailDitta = Company.EmailDitta;
CompanyToEdit.P_IvaDitta = Company.P_IvaDitta;
CompanyToEdit.CodiceAgente = Company.CodiceAgente;
CompanyToEdit.Listino = Company.Listino;
CompanyToEdit.Logo = Company.Logo;
}
break;
case EnumUseful.typeOfDatabaseOperation.CREATE:
if (Company != null)
{
dbEntity.tDitte.Add(Company);
}
break;
case EnumUseful.typeOfDatabaseOperation.SAVE:
break;
default:
break;
}
dbEntity.SaveChanges();
}
public void SaveCustomer(tCliente cliente, EnumUseful.typeOfDatabaseOperation typeOfDatabaseOperation)
{
switch (typeOfDatabaseOperation)
{
case EnumUseful.typeOfDatabaseOperation.EDIT:
tCliente CustomerToEdit = dbEntity.tCliente.FirstOrDefault(x => x.Id == cliente.Id);
if (CustomerToEdit != null)
{
CustomerToEdit.RagioneSociale = cliente.RagioneSociale;
CustomerToEdit.CodiceUniclima = cliente.CodiceUniclima;
CustomerToEdit.Indirizzo = cliente.Indirizzo;
CustomerToEdit.CAP = cliente.CAP;
CustomerToEdit.Citta = cliente.Citta;
CustomerToEdit.Provincia = cliente.Provincia;
}
break;
case EnumUseful.typeOfDatabaseOperation.CREATE:
if (cliente != null)
{
dbEntity.tCliente.Add(cliente);
}
break;
}
try
{
dbEntity.SaveChanges();
}
catch (Exception ee)
{
Console.WriteLine(ee.Message);
}
}
