public String GuardarCambios() { DTipoPlanilla tipoPlanilla = new DTipoPlanilla(); tipoPlanilla.Idtipoplanilla = IdTipoPlanilla; tipoPlanilla.TipoPlanilla = Tipo_Planilla; switch (state) { case EntityState.Guardar: Rtipoplanilla.Add(tipoPlanilla); mensaje = tipoPlanilla.mensaje; break; case EntityState.Modificar: Rtipoplanilla.Edit(tipoPlanilla); mensaje = "¡Modificado!"; break; case EntityState.Remover: Rtipoplanilla.Delete(tipoPlanilla); mensaje = tipoPlanilla.mensaje; break; } return(mensaje); }
public int Delete(DTipoPlanilla entiti) { result = 0; using (SqlConnection conn = RConexion.Getconectar()) { conn.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = conn; cmd.CommandText = "SP_DELETE_TIP_PLANILLA"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@idtipo_planilla", entiti.Idtipoplanilla); cmd.Parameters.Add("@mensaje", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output; result = cmd.ExecuteNonQuery(); entiti.mensaje = cmd.Parameters["@mensaje"].Value.ToString(); cmd.Parameters.Clear(); } } return(result); }
public int Edit(DTipoPlanilla entiti) { result = 0; using (SqlConnection connect = RConexion.Getconectar()) { connect.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = connect; cmd.CommandText = "SP_UPDATE_TIPOPLANILLA"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@nombre_planilla", entiti.TipoPlanilla); cmd.Parameters.AddWithValue("@id_tipPlanilla", entiti.Idtipoplanilla); result = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } } return(result); }
public int Add(DTipoPlanilla entiti) { result = 0; using (SqlConnection connect = RConexion.Getconectar()) { connect.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = connect; cmd.CommandText = "SP_REGISTRAR_TipPLANILLA"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@nombre_planilla", entiti.TipoPlanilla); cmd.Parameters.Add("@mensaje", SqlDbType.VarChar, 30).Direction = ParameterDirection.Output; result = cmd.ExecuteNonQuery(); entiti.mensaje = cmd.Parameters["@mensaje"].Value.ToString(); cmd.Parameters.Clear(); } } return(result); }
public DataTable GetData(DTipoPlanilla entiti) { DataTable dt; using (SqlConnection cnn = RConexion.Getconectar()) { cnn.Open(); SqlDataAdapter da = new SqlDataAdapter(); using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = cnn; cmd.CommandText = "SP_SHOW_TIPO_PLAN"; cmd.CommandType = CommandType.StoredProcedure; da.SelectCommand = cmd; using (dt = new DataTable()) { da.Fill(dt); da.Dispose(); } } } return(dt); }