public ReturnStatus SetConstant(SetConstant req) { using (var connection = new SqlConnection(_connectionString.JapaneseLearning)) { var cmd = new SqlCommand(p_Constants_Set, connection) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@UserID", _requestInfo.UserId); cmd.Parameters.Add("@RetVal", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@RetMsg", SqlDbType.VarChar, 500).Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@ConstantID", req.ConstantId); cmd.Parameters.AddWithValue("@ParentID", req.ParentId); cmd.Parameters.AddWithValue("@Name", req.Name); cmd.Parameters.AddWithValue("@Description", req.Description); cmd.Parameters.AddWithValue("@Disable", req.Disable); connection.Open(); cmd.ExecuteNonQuery(); return(new ReturnStatus(cmd.Parameters["@RetVal"].Value.ToSafeInt32(), cmd.Parameters["@RetMsg"].Value.ToSafeString())); } }
public ReturnStatus SetConstant(SetConstant req) { return(null); }