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