//METODO ADD,EDIT, DELETE public string SaveChanges() { string message; try { Dcargo dc = new Dcargo(); dc.Idcargo = idcargo; dc.Nombre_cargo = nombre_cargo; dc.Descripcion = descripcion; switch (state) { case EntityState.Guardar: cargo_repository.Add(dc); message = "¡Registrado!"; break; case EntityState.Modificar: cargo_repository.Edit(dc); message = "¡Modificado!"; break; case EntityState.Remover: cargo_repository.Delete(dc); message = dc.Message; break; default: message = "Error in Transaction!"; break; } } catch (Exception ex) { message = ex.ToString(); } finally { } return(message); }
public int Delete(Dcargo entiti) { result = 0; using (SqlConnection conect = RConexion.Getconectar()) { conect.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conect; cmd.CommandText = "SP_DELETE_CARGO"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@idcargo", SqlDbType.Int).Value = entiti.Idcargo; cmd.Parameters.Add("@message", SqlDbType.VarChar, 100).Direction = ParameterDirection.Output; result = cmd.ExecuteNonQuery(); entiti.Message = cmd.Parameters["@message"].Value.ToString(); cmd.Parameters.Clear(); return(result); } } }
public int Add(Dcargo entiti) { result = 0; using (SqlConnection conect = RConexion.Getconectar()) { conect.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conect; cmd.CommandText = "SP_REGISTRAR_CARGO"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@nom", entiti.Nombre_cargo); cmd.Parameters.AddWithValue("@descripcion", entiti.Descripcion); result = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return(result); } } }
public int Edit(Dcargo entiti) { result = 0; using (SqlConnection conect = RConexion.Getconectar()) { conect.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conect; cmd.CommandText = "SP_UPDATE_CARGO"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@nom", SqlDbType.VarChar, 40).Value = entiti.Nombre_cargo; cmd.Parameters.Add("@descripcion", SqlDbType.NVarChar, 100).Value = entiti.Descripcion; cmd.Parameters.Add("@idcargo", SqlDbType.Int).Value = entiti.Idcargo; result = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return(result); } } }
//MOSTRAR public DataTable GetData(Dcargo entiti) { using (var conect = RConexion.Getconectar()) { conect.Open(); SqlDataAdapter da = new SqlDataAdapter(); using (var cmd = new SqlCommand()) { cmd.Connection = conect; cmd.CommandText = "SP_SELECT_CARGO"; cmd.CommandType = CommandType.StoredProcedure; da.SelectCommand = cmd; using (var dt = new DataTable()) { da.Fill(dt); da.Dispose(); return(dt); } } } }