Exemple #1
0
        public void AddEspLav(LibGeCv.Curriculum c, LibGeCv.EspLav el)
        {
            //SqlConnection connection = new SqlConnection(GetStringBuilder());
            try {
                using (var db = new GECVEntities()) {
                    db.AddEspLav(el.AnnoI, el.AnnoF, el.Qualifica, el.Descrizione, c.IdCv);
                    db.SaveChanges();
                }

                /*
                 *      int Idel = 0;
                 *      connection.Open();
                 *      SqlCommand command = new SqlCommand("AddEspLav", connection);
                 *      command.CommandType = System.Data.CommandType.StoredProcedure;
                 *      command.Parameters.Add("@AnnoI", System.Data.SqlDbType.Int).Value = el.AnnoInizio;
                 *      command.Parameters.Add("@AnnoF", System.Data.SqlDbType.Int).Value = el.AnnoFine;
                 *      command.Parameters.Add("@Qualifica", System.Data.SqlDbType.NVarChar).Value = el.Qualifica;
                 *      command.Parameters.Add("@Descrizione", System.Data.SqlDbType.NVarChar).Value = el.Descrizione;
                 *      command.Parameters.Add("@IdCv", System.Data.SqlDbType.Int).Value = c.IDCV;
                 *      SqlDataReader reader = command.ExecuteReader();
                 *      while(reader.Read()){
                 *      Idel = (int)reader.GetDecimal(0);
                 *      }
                 *      el.IdCv = c.IdCv;
                 *      el.IdCv = Idel;
                 *      reader.Close();
                 *      //c.AddLav(el);
                 *      command.Dispose();
                 */
            } catch (Exception e) {
                throw e;
            } finally {
                //connection.Dispose();
            }
        }
Exemple #2
0
        public void Add(LibGeCv.Curriculum c)
        {
            try{
                using (var db = new GECVEntities()) {
                    db.AddCv(c.Nome, c.Cognome, c.Eta, c.Matricola, c.Email, c.Residenza, c.Telefono);
                    db.SaveChanges();
                }

                /* connection.Open();
                 * SqlCommand command = new SqlCommand("AddCv",connection);
                 * command.CommandType = System.Data.CommandType.StoredProcedure;
                 * command.Parameters.Add("@Nome",System.Data.SqlDbType.NVarChar).Value= c.Nome;
                 * command.Parameters.Add("@Cognome",System.Data.SqlDbType.NVarChar).Value= c.Cognome;
                 * command.Parameters.Add("@Eta",System.Data.SqlDbType.Int).Value= c.Eta;
                 * command.Parameters.Add("@Matricola",System.Data.SqlDbType.NVarChar).Value= c.Matricola;
                 * command.Parameters.Add("@Email",System.Data.SqlDbType.NVarChar).Value= c.Email;
                 * command.Parameters.Add("@Residenza",System.Data.SqlDbType.NVarChar).Value= c.Residenza;
                 * command.Parameters.Add("@Telefono",System.Data.SqlDbType.NVarChar).Value= c.Telefono;
                 * c.IDCV = RecuperaIdCv(c);
                 * command.ExecuteNonQuery();
                 * command.Dispose();*/
            }catch (Exception e) {
                throw e;
            }
        }
Exemple #3
0
        public void AddPerStudi(LibGeCv.Curriculum c, LibGeCv.PercorsoStudi p)
        {
            try {
                using (var db = new GECVEntities()) {
                    db.AddCvStudi(p.AnnoI, p.AnnoF, p.Titolo, p.Descrizione, c.IdCv);
                    db.SaveChanges();
                }

                /*connection.Open();
                *  int Idps = 0;
                *  SqlCommand command = new SqlCommand("AddCvStudi", connection);
                *  command.CommandType = System.Data.CommandType.StoredProcedure;
                *  command.Parameters.Add("@AnnoI", System.Data.SqlDbType.Int).Value = p.AnnoInizio;
                *  command.Parameters.Add("@AnnoF", System.Data.SqlDbType.Int).Value = p.AnnoFine;
                *  command.Parameters.Add("@Titolo", System.Data.SqlDbType.NVarChar).Value = p.Titolo;
                *  command.Parameters.Add("@Descrizione", System.Data.SqlDbType.NVarChar).Value = p.Descrizione;
                *  command.Parameters.Add("@IdCv", System.Data.SqlDbType.Int).Value = c.IDCV;
                *  SqlDataReader reader = command.ExecuteReader();
                *  while(reader.Read()){
                *  Idps = (int)reader.GetDecimal(0);
                *  }
                *  p.IDCV = c.IDCV;
                *  p.IDPS = Idps;
                *  reader.Close();
                *  c.AddPS(p);
                *  command.Dispose();*/
            } catch (Exception e) {
                throw e;
            } finally {
                //connection.Dispose();
            }
        }
Exemple #4
0
        public void AddCompetenze(LibGeCv.Curriculum c, LibGeCv.Competenze t)
        {
            //SqlConnection connection = new SqlConnection(GetStringBuilder());
            try {
                using (var db = new GECVEntities()) {
                    db.AddCompetenze(t.Tipo, t.Livello, c.IdCv);
                    db.SaveChanges();
                }

                /*
                 *      connection.Open();
                 *      int Idcomp = 0;
                 *      SqlCommand command = new SqlCommand("AddCompetenze", connection);
                 *      command.CommandType = System.Data.CommandType.StoredProcedure;
                 *      command.Parameters.Add("@Tipo", System.Data.SqlDbType.NVarChar).Value = t.Tipo;
                 *      command.Parameters.Add("@Livello", System.Data.SqlDbType.Int).Value = t.Livello;
                 *      command.Parameters.Add("@IdCv", System.Data.SqlDbType.Int).Value = c.IDCV;
                 *      SqlDataReader reader = command.ExecuteReader();
                 *      while(reader.Read()){
                 *      Idcomp = (int)reader.GetDecimal(0);
                 *      }
                 *  t.IDCV = c.IDCV;
                 *      t.IDCS = Idcomp;
                 *      reader.Close();
                 *      c.AddCompSpec(t);
                 *      command.Dispose();
                 *
                 */
            } catch (Exception e) {
                throw e;
            } finally {
                //connection.Dispose();
            }
        }